Read Sheet name from Excel file into Word field

[George Georgieff]

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

 

[Cindy M -WordMVP-]

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