Viewing a .doc in excel
 

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 . . .

Viewing a .doc in excel
 

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" wrote in message
...
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 . . .

Viewing a .doc in excel
 

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" wrote:

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" wrote in message
...
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 . . .

Viewing a .doc in excel
 

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



"teo410" wrote in message
...
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" wrote:

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" wrote in message
...
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 . . .