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