| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to copy a worksheet to word as a picture
Hello,
I'm trying to find some VBA code that will copy a worksheet, from excel (2000), and paste it as a picture into word (2000). I have found a few online but they don't copy it as a picture and/or copy all the sheets in the workbook. I look forward to anyones help. Thanks you in advance Marc |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA to copy a worksheet to word as a picture
Activesheet.UsedRange.CopyPicture
Puts the range in the clipboard as a picture. See help on CopyPicture for details. -- Regards, Tom Ogilvy "Marc" wrote in message ... Hello, I'm trying to find some VBA code that will copy a worksheet, from excel (2000), and paste it as a picture into word (2000). I have found a few online but they don't copy it as a picture and/or copy all the sheets in the workbook. I look forward to anyones help. Thanks you in advance Marc |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How copy editable text from Excell to Word and not get a picture? | Excel Discussion (Misc queries) | |||
| Copy worksheet into Word | Excel Discussion (Misc queries) | |||
| Copy / paste from a table in word .doc to excel .xls worksheet | Excel Discussion (Misc queries) | |||
| Copy and Paste Chart as Picture into another workbook or worksheet | Charts and Charting in Excel | |||
| How to extract a picture from an Excel worksheet into a picture fi | Excel Discussion (Misc queries) | |||
![Marc[_11_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
