Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Read 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 |
#2
|
|||
|
|||
Hi ?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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Envelope Address | New Users | |||
Quotation marks (") in tab delimeted file causes loss of formattin | Mailmerge | |||
Is there a Fast Search in Word? | New Users | |||
Boiletplates from Word Perfect | Microsoft Word Help | |||
Continuous breaks convert to next page breaks | Microsoft Word Help |