sdawson
Registered User.
- Local time
- Today, 07:58
- Joined
- Apr 22, 2003
- Messages
- 165
I'm using a simple command, similar to below, to transfere 40 cells from a spreadsheet in a table.
DoCmd.TransferSpreadsheet acImport, 0, _
"mytable","C:\Data\mysheet.xls", False, "A1:A40"
Can this be modified to import from an active spreadsheet without specifying the path?
Ta
DoCmd.TransferSpreadsheet acImport, 0, _
"mytable","C:\Data\mysheet.xls", False, "A1:A40"
Can this be modified to import from an active spreadsheet without specifying the path?
Ta
Last edited:
