 |
 | 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 / Mailmerge and Fax / June 2005Read Sheet name from Excel file into Word field
I want to include the name of sheet from Excel files. For example: i have a excel file "MyExcel.xls" with two sheet "MySheet1" and "MySheet2" . I linked 2 excel tables i Word document and I want to put two field witch shows the name of sheets Hi =?Utf-8?B?R2VvcmdlIEdlb3JnaWVmZg==?=, > I want to include the name of sheet from Excel files. > For example: i have a excel file "MyExcel.xls" with two sheet "MySheet1" and > "MySheet2" . I linked 2 excel tables i Word document and I want to put two > field witch shows the name of sheets Word doesn't provide any buillt-in functionality that will pick up the name of an Excel sheet. Not even one linked into Word. You'd need a macro solution in order to avoid any manual labor. 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.