HI I'm using a RunMenuCommand.ExportExcel function in a macro and it seems to be working fine except it MSAccess allows me to create an .xls file and the application i'm uploading this spreadsheet to requires a .csv formatted version.
The only way i can see to deal with this is to save the .xls file - reopen it and resave it as .cvs.
Is there a way to do this without all the extra steps?
thanks in advance.