Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying spreadsheet data to WORD
I am using Office 97.
I have a workbook with a number of worksheets in it. Is it possible to copy a range from each worksheet, one sheet at a time and paste special as a picture/bitmap into a new WORD document? If so, can anyone assist me with some code, please? -- Mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying spreadsheet data to WORD
Turn on the macro recorder in Excel
select a range, hold down the shift Key and select Edit=copy Picture No turn off the macro recorder. Go to word, turn on the macro recorder. Select in word and do Edit=Paste Turn off the macro recorder. Now you can combine the recorder macros with alterations to match you actual requirements. For help on automating word: http://support.microsoft.com/?id=165926 OFF97: Can't Dimension Word as Application from Other Program (Examples of Working with Word 97 using OLE) http://support.microsoft.com/?id=167223 OFF97: Microsoft Office 97 Automation Help File Available (Q167223) http://support.microsoft.com/?id=260410 OFF2000: Microsoft Office 2000 Automation Help File Available (Q260410) http://support.microsoft.com/?scid=253235 FILE: OFFAUTMN.EXE Discusses Office 97 and 2000 Automation and Provides Sample Code -- Regards, Tom Ogilvy "Mark" wrote in message ... I am using Office 97. I have a workbook with a number of worksheets in it. Is it possible to copy a range from each worksheet, one sheet at a time and paste special as a picture/bitmap into a new WORD document? If so, can anyone assist me with some code, please? -- Mark |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying spreadsheet data to WORD
Thanks Tom: helpful reference
j. "Tom Ogilvy" wrote: Turn on the macro recorder in Excel select a range, hold down the shift Key and select Edit=copy Picture No turn off the macro recorder. Go to word, turn on the macro recorder. Select in word and do Edit=Paste Turn off the macro recorder. Now you can combine the recorder macros with alterations to match you actual requirements. For help on automating word: http://support.microsoft.com/?id=165926 OFF97: Can't Dimension Word as Application from Other Program (Examples of Working with Word 97 using OLE) http://support.microsoft.com/?id=167223 OFF97: Microsoft Office 97 Automation Help File Available (Q167223) http://support.microsoft.com/?id=260410 OFF2000: Microsoft Office 2000 Automation Help File Available (Q260410) http://support.microsoft.com/?scid=253235 FILE: OFFAUTMN.EXE Discusses Office 97 and 2000 Automation and Provides Sample Code -- Regards, Tom Ogilvy "Mark" wrote in message ... I am using Office 97. I have a workbook with a number of worksheets in it. Is it possible to copy a range from each worksheet, one sheet at a time and paste special as a picture/bitmap into a new WORD document? If so, can anyone assist me with some code, please? -- Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying a large spreadsheet into Word | Excel Discussion (Misc queries) | |||
copying large spreadsheet into Word | Excel Discussion (Misc queries) | |||
Copying data from Word | Excel Worksheet Functions | |||
Copying an Excel spreadsheet to a Word document | Excel Discussion (Misc queries) | |||
copying data from word to excel | Excel Programming |