| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accesing Word Document from Excel???
Hi, This could be an interesting one for someone! I have a spreadsheet with an AutoShape and when I click on it it opens up a word document. This seems to be embedded in the workbook, it is not an external word doc. I decided to see what code is required to open this word doc. and recorded the macro. This is the piece of code: Application.Run "'PMI Full WkBk.xls'!Sheet291.ProjectSummary" ["ProjectSummary" is the word doc I presume. I cannot find any "Sheet291"] Now, what I want to do is call up this word document from another spreadsheet and copy the contents of it into this new spreadsheet. Any takers! Thanks in advance Liam -- wjoc1 ------------------------------------------------------------------------ wjoc1's Profile: http://www.excelforum.com/member.php...o&userid=15281 View this thread: http://www.excelforum.com/showthread...hreadid=386138 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Accesing Word Document from Excel???
The line Application.Run "'PMI Full WkBk.xls'!Sheet291.ProjectSummary
launches an Excel macro from workbook PMI Full WkBk.xls in worksheet Sheet291. In there you'll probably find the word doc specs. But isn't it easier to add a hyperlink to your shape, open the doc, copy the content and dump it in a new worksheet? "wjoc1" schreef in bericht ... Hi, This could be an interesting one for someone! I have a spreadsheet with an AutoShape and when I click on it it opens up a word document. This seems to be embedded in the workbook, it is not an external word doc. I decided to see what code is required to open this word doc. and recorded the macro. This is the piece of code: Application.Run "'PMI Full WkBk.xls'!Sheet291.ProjectSummary" ["ProjectSummary" is the word doc I presume. I cannot find any "Sheet291"] Now, what I want to do is call up this word document from another spreadsheet and copy the contents of it into this new spreadsheet. Any takers! Thanks in advance Liam -- wjoc1 ------------------------------------------------------------------------ wjoc1's Profile: http://www.excelforum.com/member.php...o&userid=15281 View this thread: http://www.excelforum.com/showthread...hreadid=386138 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I convert an Excel document to a Word Document | Setting up and Configuration of Excel | |||
| change excel document into word document | Excel Discussion (Misc queries) | |||
| convert excel document to word document (not a picture) | Excel Discussion (Misc queries) | |||
| How do I convert a word document into a Excel document | Excel Discussion (Misc queries) | |||
| How to change a excel document into a word document? | Excel Discussion (Misc queries) | |||
![wjoc1[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
