Excel VBA saving csv files to a specified path?

[knifey]

Hi,
I have a file converter written in Excel VBA that needs to output all worksheets in csv format to an output directory path specified in the Excel worksheet (the folder is called 'Output'). It then needs to zip these csv files and rename the zip.
My problem is I can't get the csv files to save in the correct directory. They save in the current workbook directory with names such as OutputClients.csv, OutputPatients.csv, etc.
Can anyone advise?
Thanks,
Roy

 

[SkipVought]

Hi,

With Thisworkbook
  sFName =  .path & "\Output\" & YourFileName 
end with

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[PHV]

What is your actual code creating the csv ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886