import Word document as several objects, one page at a time

Hello all,
I am looking for a solution to the problem of page breaks in OLEObjects. how about a macro that lets the user browse to pick the Word document, then imports it one page at a time as separate word.document12 objects for each page, and places them one below the other in Excel starting at the current cell?
If anyone knows how to modify the code below to open a dialogue to browse and select a file, then add only the first page of the chosen document that might be a great start:

Please Login or Register  to view this content.

Thanks in advance,

Willardio

Williardo

Does the user have to browse the document via Excel?

Couldn't you actually open Word?

Norie,
Word would presumably be open already since the user will most likely have just finished writing the document that is being imported. What did you have in mind?

All I was thinking of was having hyperlinks, or something like that, to the Word files.

I'm not really sure what you are doing though so I don't know if that would be suitable.