Copying spreadsheet data to WORD

[Guest]

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?

 

[Tom Ogilvy]

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

 

[Guest]

Thanks Tom: helpful reference

j.

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