I'm using a Word macro to import an Excel spreadsheet into word, using AddOLEObject.
The problem is, the spreadsheet is wider and deeper than 1 page (maybe about 1/4 page more).
When it is imported into Word, no matter how much I shrink the object, only the columns and rows from page 1 are displayed in Word.
How can I get the object in Word to show all the data from the spreadsheet??
THIS IS AN URGENT PROBLEM!
ANY SUGGESTIONS WELCOME...
It is not practical for me to reduce the Excel spreadsheet down to 1 page.
I need Word to be able to display the full spreadsheet.
NOTE: I am using Office 2000.
And it needs to also work on Office XP (not tested yet).
ps. I need to get the Word macro to do this. I am thinking that there must be some property or method of the object I can use...
But any suggestions as to how to do this outside of macros may be helpful also.