Really close to figuring out this import issue

[nhylan]

I am really close to figuring this import method out. If the file that I'm importing from is open it does import but otherwise I'm getting run-time errors 424 or 3274. I don't know if the issue is something on the range I've selected or what but if you have any ideas I'd really appreciate it.

Private Sub Command61_Click()
    DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12Xml, "t1blotter", "G:\ROCK\Trade Processing Unit\Trade Recaps\Blotters\BLK-SSBEAST_Trade_Recap" & Format(Date - 1, "_mmddyyyy_2100.xl\s"), True, "A11:CM1048576"
End Sub

Thanks!

[June7]

Probably need to prefix the range with sheet name.

"Sheet1!A11:CM1048576"

[nhylan]

Thanks June7. Would you apply whatever the name of the tab was or will sheet1 always work for the first tab in the workbook?

[June7]

I have seen issue with reference to SheetX if the sheets are created then rearranged, otherwise should work.