Viewing a .doc in excel

[teo410]

A collegue of mine wants to view a word document in excel AS HE SEES IT IN
MICROSOFT WORD. Same formating, margins, layout everything. Didn't know if
this was possible but after reading a few questions in this disscusion group
think one of you clever people may be able to show me a way . . .

 

[Peter T]

In Excel 97-2003 (along similar lines in 2007)
Insert, Object, Create from File, Browse to your doc

Experiment with the various options, also try resizing the object

Regards,
Peter T

 

[teo410]

Didn't realise it was that easy! Thank You!

One quick question; its only showing the first page, any ideas how this can
see the rest of the document?

 

[Peter T]

How about just select the object, then you will in effect be working
directly with the Word object and will be able to scroll down. Could do that
programmatically

ActiveSheet.OLEObjects("Object 2").Verb Verb:=xlPrimary

If you are happy to work with Word VBA you could start with

Dim objDoc as Object
Set objDoc = ActiveSheet.OLEObjects("Object 1").Object

and go from there

Regards,
Peter T