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 :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Integrating information from Word to Excel (not mail merge) 1
Default local file location - folder redirection slowness 0
Merging from an Excel file with graphics 1
Excell Otpions in office environment 0
Extract embedded excel file from word document 0
Autonumber field in Excel that behaves the same as Access 0
Excel - Wich Function should I use? 1
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0

Top