Aug 6, 2002 #1 kinselas IS-IT--Management Aug 4, 2002 60 0 0 AU Please Help This is code below was suggested I tried but comes up with an error "Compile error" invalid outside procedure. DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Outlets", "u:\Extract.xls", True
Please Help This is code below was suggested I tried but comes up with an error "Compile error" invalid outside procedure. DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Outlets", "u:\Extract.xls", True
Aug 6, 2002 #2 bdmclennan Programmer Aug 2, 2002 28 0 0 GB acSpreadsheetTypeExcel9 should read acSpreadsheetTypeExcel97 Upvote 0 Downvote
Aug 6, 2002 #3 bdmclennan Programmer Aug 2, 2002 28 0 0 GB acSpreadsheetTypeExcel9 should read acSpreadsheetTypeExcel97 Cheers B. Upvote 0 Downvote