Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . . . |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . . . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . . . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formula viewing | Excel Worksheet Functions | |||
Help with viewing data - Excel XP | Excel Discussion (Misc queries) | |||
Help with viewing data - Excel XP | Excel Discussion (Misc queries) | |||
Viewing Excel through a web-browser | Excel Programming | |||
viewing excel | Excel Discussion (Misc queries) |