Search results

I wrote the following code in visual basic to copy column C to column IH in an excel worksheet but I get this error when trying to select column C: Run-time error '1004': Select method of Range class failed Sub TestExceladfd(current_path, rnc As String) 'subroutine copies the...

Thanks for the response. I can't import the whole spreadsheet to a transitional table beacause it has too many fields.

I am trying to import a large spreadsheet into access with the following code: DoCmd.TransferSpreadsheet acImport, , "import_" & worksheet_list!worksheet, path & "\input_files\" & rnc_list!RNC & ".xls", True, worksheet_list!worksheet & "!A:HA" But I get this error: search key not found...