- Local time
- Yesterday, 23:37
- Joined
- Feb 19, 2002
- Messages
- 43,266
Technically, no. You wrote code to perform a one-time simple fix. I didn't test the code. I'm assuming it works. But there was no need to write code to solve the problem.did i not also suggest it in post #2 and #9?
The code would be very useful if there were a bunch of queries that needed to be fixed up or if the same query needed to be fixed up each time you used it - which is what the example showed.
I know that the solution in #12 is just too simple to impress anyone but the fact is, it works.
@Richard Horne The problem with the original solution is that you were using the wrong type for the spreadsheet. Not obvious but the correct value is acSpreadsheetTypeExcel12Xml. The version without the xml at the end creates a binary spreadsheet with a different extension than .xlsx. I think you'll find that the Transferspreadsheet method works if you change the type. Please try it and confirm.