Hi i'm quite new to access and was figuring out how to program using the DoCmd.TransferSpreadsheet.
I have a code attached to a a button like below
DoCmd.TransferSpreadsheet acImport, 8, "Bony2", "C:\Documents and Settings\XXXX\Desktop\3.xls", True, "A1:K80"
the probelm is i want the user to specified the cell range to import. Maybe i can give a text box for user to enter that value but how to transfer that value back to the above code.
If i don't want the user to specify the range and leave it blank in the above code....access always prompt me that a field doesn't exist in my access database. However i had everything in tact and the required field and property done up. If i specified the range then everything is ok. So anybody can advice?