Programatically Import Multiple Tabs

  • Thread starter Thread starter Sash
  • Start date Start date
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?
 
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
 
Back
Top