Saving file as xls with VBA code ?

[pookie62]

Hi all,
I've got a downloaded (through php) file with xls extension, but in fact it's not a real xls file. When I open manually (in Excel) and click 'Save as' it's offering to save as a textfile. When I save it as xls, the file grows in size and then I can run VBA code on it which edit some values then close it.

Question is: How can I save this as a real xls file through VBA code ??

Thanks

 

[Pat Hartman]

Sounds like it is really a .csv file. Try linking to the file by using the TransferText Method/Action and then try exporting the linked file by using TransferSpreadsheet.