Save file as CSV from XLS after VBA applied

Hi,

I have a set of VBA code that opens my template.xls file and moves specific data over from the file I open which is also an XLS file.

When I run the below script it saves each file as a CSV which is what I want but it is not a true CSV file as when I open it in notepad the format is that of an excel file.

The test.xls contains the below VBA and I have also attached the Template.xls

Here is my current VBA below:

Please Login or Register  to view this content.

Thanks for any help,

David

to save as csv you have to use saveas, not close Savechanges

Hi, David,

maybe you can save a lot of time when you just open the template once and clear teh contents isnstead of closing the saved file and opening the template again.

Maybe give this code a try:

Please Login or Register  to view this content.

Iīm afraid I donīt understand

It just the formatting that I need to save as.

No formatting is transferred when you copy values directly. Or do you mean the suffix?

Ciao,
Holger