Importing from a excel file from a spasific Worksheet

A

AJOLSON

I am useing the following command to import information from an excel file
DoCmd.TransferSpreadsheet acImport, , "InputTbl", "C:File\BAT.xls", False

My problem is that it will only import from the first excell worksheet in
this file. I want to import other data from othe worksheets within this
file.

How would I code to pull from a worksheet named "Template?" It is the third
worksheet from within this file.

Thanks
Andy
 

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

Embedded Excel into Word with Tables 0
Name of file opened, being viewed 2
Embed the same Excel multiple times 0
Problem Importing Specific Worksheet From Workbook 6
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Merging from an Excel file with graphics 1
Extract embedded excel file from word document 0
Excel Multiple Worksheets - TransferSpreadsheet VBA 0

Top