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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Insert a two-page Word document into a worksheet
- Thread starter phantom1975
- Start date
Barry Katcher
Well-known Member
- Joined
- Feb 25, 2002
- Messages
- 4,053
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
Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
phantom1975
MrExcel MVP
- Joined
- Jun 3, 2002
- Messages
- 3,962
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
Barry Katcher
Well-known Member
- Joined
- Feb 25, 2002
- Messages
- 4,053
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.
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
phantom1975
MrExcel MVP
- Joined
- Jun 3, 2002
- Messages
- 3,962
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
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
