 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Programming / February 2006Embedding an excel document in a word doc
I would like to create link via a macro in word that allows the user to attach an excel file that they browse to find and then compete the procedure manually Can this be done?can you provide an example? > I would like to create link via a macro in word that allows the user > to attach an excel file that they browse to find and then compete the > procedure manually The link to an Excel file is maintained in Word by a LINK field. Go through the steps manually, then press Alt+F9 to see the field code. The macro would display a dialog box to get the path information from the user. It should then use the Fields.Add method to create the LINK field. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) unfortunaltey I am a novice so I haven't been able to make much progress trying to apply these ideas thanks for the reply > unfortunaltey I am a novice so I haven't been able to make much > progress trying to apply these ideas Hmmm. I'm mentally trying to come to terms with a Word novice trying to create a macro for linking outside the Word application... What steps would you normally use to bring the Excel information into Word and link it? And which version of Office are you using? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-)
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.