what's the range to import fifth sheet only (columns A to D)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I used TransferSpreadsheet to import the first sheets from Excel file. Now I
want to do the same thing but this time I want to import only the fifth sheet
with name INCOME of excel file and to import the first 4 columns (A to D).
Using TransferSpreadsheet I know can put the range. Can you tell me how to
write the range for this problem

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblTemp",
strFile, True, "........."
Kostas
 
Back
Top