aziz rasul
Active member
- Local time
- Today, 00:19
- Joined
- Jun 26, 2000
- Messages
- 1,935
I have the following code: -
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblIREMarginalReportTemp", _
"M:\MS Excel Files\GP\Ireland\Ire Wk 2 2006\IRE MR 2 06.xls", False, "'Working Document'!"
When I run the code I get the error: -
Run-time error '3125':
"Working Document'$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.
Does anyone understand why I get this?
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblIREMarginalReportTemp", _
"M:\MS Excel Files\GP\Ireland\Ire Wk 2 2006\IRE MR 2 06.xls", False, "'Working Document'!"
When I run the code I get the error: -
Run-time error '3125':
"Working Document'$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.
Does anyone understand why I get this?