Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: AlanTylman
- Order by date
-
TransferSpreadsheet is creating 3 sheets
Gave that a try and while it reduced the sheets to 2 they both had data on them and some data errors (#VALUE). Thought I'd give it another run just in case and voila!, 1 sheet, no errors. Thanks for your assistance!- AlanTylman
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
TransferSpreadsheet is creating 3 sheets
Yes, I've even tried acSpreadsheetTypeExcel8 and acSpreadsheetTypeExcel10 but to no avail. On a side point I've still be unable to ascertain exactly what the differences are between these even from the MS site.- AlanTylman
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
TransferSpreadsheet is creating 3 sheets
Hi I am trying to export a query from Access 2003 to Excel 2003 that has over 17000 lines and I am trying to use the TransferSpreadsheet command as below. DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "{query name}", "{file path}" The spreadsheet is created but has 3 sheets...- AlanTylman
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
