Insert a two-page Word document into a worksheet

phantom1975

MrExcel MVP
Joined
Jun 3, 2002
Messages
3,962
I need to be able to insert a two-page Word document into a worksheet. I tried inserting the document as an object, but I only get part of it to show up.
 
Phantom, if you double right click on the object, you get the drop down box and you can format the object, including size. But it's really difficult and I couldn't get it right. But try that, maybe you'll have better luck.
 
Upvote 0

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
The problem seems to be that it converts the document into a picture and the formatting is lost in the conversion. I am amazed that there isn't a smoother integration of Office documents.
 
Upvote 0
Beats me. When I insert the Word file as an object, it DOES bring over all the formatting; bold, colored text, fonts, etc.

Plus, you can re-format right in the object in Excel (see my edit to my 2nd message).

Don't know why it's not bringing over your formatting. With it being so hard to re-size and show the additional pages, this would be a pain in the second neck.

Leaving office now, pick up thread at home.
 
Upvote 0
Well, since I can't seem to get it to appear in a worksheet, I have found an alternative. I can embed it as an icon and double-click the icon to open it.

I now need help setting up a CommandButton that will open this embedded object and print it. I have named the object LOAForm. This is what I have so far:

Private Sub CommandButton1_Click()
Sheets("Appendix").Activate
ActiveSheet.Shapes("LOAForm").Select
Selection.Verb Verb:=xlPrimary
End Sub


This will open the document up in Word. I need it to then print both pages and then close Word.
_________________
****************** EXCEL/VB NEWBIES ARE MY FAVORITE! ******************
The only dumb question is the one that isn't asked. Pass on what you have learned.
This message was edited by phantom1975 on 2002-12-27 17:03
 
Upvote 0
This was a God send. I was trying to do this same thing. Try Barry's solution but first seperate your Word documents into one page files. (pg1A.doc, pg1B.doc, etc...) Format them in Word, (I decreased the margins) and that worked for me.
 
Upvote 0

Forum statistics

Threads
1,224,000
Messages
6,175,896
Members
452,681
Latest member
jlcm0924

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top