Importing from Excel to Access using VB

J

Joe Naveira

Is there any way that you can get the name of the tabs contained in the Excel
file to be imported in access using Access VB?
 
C

Cindy M.

Hi =?Utf-8?B?Sm9lIE5hdmVpcmE=?=,
Is there any way that you can get the name of the tabs contained in the Excel
file to be imported in access using Access VB?
Click to expand...
I'm not sure I understand your question. But the tabs with the worksheet names
(if that's what you mean) can be "read" by querying the objWorksheet.Name
property.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
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 :)
 
Top