Hello,

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:

MyXLWbk.SaveAs "blahblah.xls"

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,
Tom

What is the problem saving the file as a csv? You can still pull the data. Are you having an import problem?

mmcdonal