Reply to thread

Message: [QUOTE="Brad, post: 6450171"] I have to open worksheets and then save them as CSV files for another program. When I used the macro recorder, it copied the entire path so that when I run macro is puts the file back in the same folder every time regardless of path for the XLS file. All the file names are VOLUME, but the path changes for the various options. How do I edit the macro below to get it to save XLS files as CSV files in the same directory that the XLS file cam from instead of the one where I initially recorded the macro? Active..SaveAs Filename:= _ "Y:\Yarger Engineering\20090802\Synchro\Phase 1 (2011)\Sunday\AM\VOLUME.csv" _ , FileFormat:=xlCSV, CreateBackup:=False If it makes any difference, I do this all the time, but the path structure changes from project to project. I would like to automatically open, update, save and then save as CSV file, but I have no idea how to set up a macro to loop within an unknown path for future projects. The first part of the path will always be "Y:\Yarger Engineering\" followed by the project number and name, then "synchro", phase or year, maybe the day of week but normally not since we normally don't worry about weekends, and then the time of day. I may have an upcoming project where I will have to do this 200 times, so I really don't want to have to do this manually any more. In some cases, this will be creating the first CSV file and in others it will overwrite an existing CSV file. Brad Excel 2002 on XP Pro SP 3 [/QUOTE]

Verification