save as XLS 1

[scottie1]

Hi Guys

Is there a way to get a folder which has .CSV files in it, t be opened then saved as .XLS files in another folder.

need help.
Must be a common question

 

[SkipVought]

scottie1,

Please explain what you want to happen step by step.

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[scottie1]

Hi Skipvought

I will have a list of file names in a spreadsheet these files will all be saved as .csv files in a folder somewhere on a network drive. What i want to do is some how open these files aoutomatically from my list, save them as .XLS format instead of .CSV files in a new folder.

 

[SkipVought]

Something like this...

for each c in range("MyListOfCVS")
  workbooks.open OlnPath & c.value
  with aciveworkbook 
    .saveas NewPath & c.value
    .close
  end with
Next

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[SkipVought]

Something like this...

for each c in range("MyListOfCVS")
  workbooks.open OldPath & c.value
  with aciveworkbook 
    .saveas NewPath & c.value
    .close
  end with
Next

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[scottie1]

Spot on