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

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

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