Programatically Import Multiple Tabs

S

Sash

I have a spreadsheet with 2 tabs that my user needs to import every other
week. The sheets tab and columns will be named the same from week to week.
My program currently has the user select the spreadsheet via a Windows
Explorer window, but only imports the first tab. Is there a way to select
and import the second tab programatically?
 
S

Sash

Got it working....the short of the code is here...

stTable2 = "TermEEUMK"
stSheet2 = "TermEE-UMK!A1:BY6000"
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel3, stTable2,
fileName, True, stSheet2
 

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

Consolidation Table from Different Excel Tabs with Different Format 1
Drop down list control value in vba 2
Converting excel to PDF, single page converts to multiple HELP! 1
Query from an Excel spreadsheet 0
Identify letters but not spaces 2
How to sync OL365 contacts and calendar to iPhone without iTunes? 1
Copy tab from one spreadsheet to multiple tabs in another spreadsheetwhile retaining the targets spr 15
Trouble importing foreign language accents into Access 2003 11

Top