Create CSV w/ variable name

[frank35]

How do I generate a csv file from one sheet with a name that has an ending number that goes up if the file with that number already exists?

[Marc L]

With Dir function you can check if the file already exists …

[frank35]

and then? do I just add Dir somewhere and it will change the name?

[Marc L]

Hey, it's just pure logic !

If the file exists, you must increment the ending number …

[ranman256]

Put these macros in a module, then get the filename by: vFile = getSaveFile(originalFileName)

Please Login or Register  to view this content.

[frank35]

one thing, I'm only familiar with subs, how do I integrate this into a sub?, where does it ask which sheet to use from the workbook?