Saving an excel file in Access VBA
I've written a procedure that takes an Excel file in CSV format. Modifies it and then saves the Excel file in XLS format for importing.
It's all part of a bigger procedure and therefore must be fully automated. The problem I'm having is that when I save the workbook using:
The file is saved as "blahblah.xls" but the format is still CSV (ie. the same result that would be expected from simply changing the file extension of a csv). How can I specify the file format of the file as I save it ?
Thanks in advance,