VBA SaveAs CSV files

[George_Hart]

Hi

I have a couple of csv files that I open, copy sepcific data and paste into an excel file. What I then need to do is save the csv files into another folder.

I have the code below but it just saves both csv files as the same name so when it saves the second one it advises that it already exists???
Any ideas will be most apreciated

Please Login or Register  to view this content.

[ragulduy]

It looks like the saveas command uses the variable "strFileName" which doesn't change as you loop through the files, maybe but the strFileName line in the do while loop:

Please Login or Register  to view this content.

[George_Hart]

Brilliant - worked a treat. Thanks very much...