how to import word document into Excel - multiple word pages

[Jissenka]

Hi,
Here's hoping someone can help I found the following code that when run, asks you to select a word doc and then imports it into the active workbook, on a new tab which you can name.
This works if your word doc only has 1 page.

My question is, how do I modify this code to copy multiple pages and paste them one after another in excel.
Ideally if the code would read how many pages the word doc has and paste all pages into the same worksheet and adjust the print layout to suit.

Thanks in advance.

Please Login or Register  to view this content.

[Jissenka]

Hello again,
Thanks to all those that viewed, still no answer, just wondering is my question not clear? can I do anything else to help someone help me?

I was thinking how could I have the code read the selected Word Document copy the first page paste at A1 on the desired worksheet,
then loop through each page of the word document and paste each below the previous?

Hopefully that hasn't muddied the waters.

Cheers,
Brad

[TnTinMN]

Part of the problem is that the code you have shown does not insert only the first page of the Word document. It embeds a link to MS Word that opens the document inside of Excel. You just see the first page, if you double click on it, you can edit it just like in Word.

What is it that you really need to accomplish?

Do you need to just see the text? Would a picture suffice?

Or do you need the ability to edit the text inside of Excel?

[Jissenka]

Thanks TnTinMN for your reply.

All I need is to make an image of each page and paste them into excel worksheet, one under each other.
No linking and no editing needed.

Thanks you.

[TnTinMN]

You are going to need to work with the MS Word Object Model from within an Excel macro to open the document and determine the character Range that defines each page. Once you have that then you can use the Word.Range.CopyPicture method to place the bitmap on the clipboard. Then you would use the Excel.Worksheet.Pictures.Paste method to add the picture to the desired Worksheet.

[Jissenka]

Thanks TnTinMN for your reply.

Unfortunately I'm still a novice, and not sure how to go about what you're suggesting.
I'm still at the stage of reading and modifying code.
If anyone has code that I can use and try to decipher to learn from I would appreciate it.

Cheers,
Brad.

[TnTinMN]

Unfortunately I'm still a novice, and not sure how to go about what you're suggesting.
I'm still at the stage of reading and modifying code.
If anyone has code that I can use and try to decipher to learn from I would appreciate it.

Why not use the tools you have to create your own examples? Both Word and Excel have macro recorders. If you want to learn, do it. If needed, ask a question on how to accomplish very specific task.

Programs to not materialize out of the Void. They are designed as sequence of operations. Layout the steps you need to accomplish the task.

You want to automate a process that you could accomplish manually by selecting a page in Word, copying it and then pasting it as a picture in Excel. I have given you a few hints as what to look for.

Open up or create a multipage document in MS Word. To select a page, you need a start and end point (the two basic properties of a Word.Range object). Use the Find->Goto Page # command to move to the beginning of a specific page and observe what code is recorded. Use the built-in help for code commands that you do not understand (F1 is your friend).

Once you get the basic code for selecting each page worked out in Word-VBA then you can copy it over to Excel and with a few modifications you can make this work.

[Jissenka]

Thanks Again TnTinMN for your reply.

I will explore and try your suggestions.
I will post what I come up with.

Thanks,

Brad