VBA code to access PasteSpecial -> Excel Worksheet 
Author Message
 VBA code to access PasteSpecial -> Excel Worksheet

I want to copy an Excel spreadsheet and paste it into the body of an Outlook
message using VBA code. I have the rest of the code working to create the email,
address it and send it, but I can't figure out how to access the Edit -> Paste
Special method.

If I do it manually, I go to Edit -> Paste Special, and when the Paste Special
dialog box comes up, I select the Paste option and As: is Microsoft Excel
Worksheet. Then click OK.

I want to be able to do this programmatically. Can anyone tell me how?

Mon, 01 Dec 2003 23:18:29 GMT  
 [ 1 post ] 

 Relevant Pages 

1. add new Worksheet in Excel with VBA-Code

2. Using VB (or VBA) to call code in multiple worksheets of an Excel app

3. Access/VBA: Creating New Excel Worksheets?

4. PasteSpecial macro in Excel VBA

5. VB/VBA: Accessing ActiveCell info in an embedded Excel Worksheet

6. Excel->VBA->Help->Visual Basic Help

7. how to search a worksheet in excel using VBA

8. Using Excel Worksheet Functions in VBA

9. Export Excel worksheets to separate files (VBA)

10. Adding A Worksheet in Excel Using VBA

11. Excel VBA: selecting a worksheet

12. wsh/vba for excel automation: moving worksheets beetween workbooks


Powered by phpBB® Forum Software