TransferSpreadheet: Importing a Specific Spreadsheet

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

I've tried looking at previous answers to my particular TransferSpreadsheet
issue, in this forum, but I cannot make them work for me.

I can make the TransferSpreadsheet work using VBA code; however, the first
spreadsheet is selected by the function. I need to specify other worksheets
in the workbook. I'm not an expert in Access VBA, so I'm requesting in a
humble manner for someone to show me how to select specific sreadsheets in
the simplest manner possible.

The line of code I used is shown below. It worked, but it selected the
first spreadsheet in my Excel file.

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, "tblBAKERY",
Me.PATH_STATEMENT & "" & Me.FILE_NAME, True

Any help would be greatly appreciated.
 
Back
Top