Code to create a custom .csv filename with version stamp in filename

[Gti182]

Hi All,

I've been struggling to write some code to create a .csv file with an updating version stamp filename.

I have an original excel file which i use to do formulas in but need to create a .csv file from this data which will be used to load into some financial software.

Every month i will be resaving the primary excel file in the latest monthly folder and manually update the filename (Adj - Jun12, Adj - Jul12, etc.) but i would like to run a .csv file to save in the same location as the primary excel file and give it a version stamp in the filename automatically.

Example below.


Adj - Jun12 (main excel file)
to create .csv file with name: Adj_v1_JUN-2012 (first run)
to create .csv file with name: Adj_v2_JUN-2012 second run, etc.

hope this makes sense.

TIA
Neill

[abousetta]

Do you currently save the csv file programmtically or manually? If the former then you can save the current version number to a second worksheet and use that or use filesystem object to detect if the file already exist and then adjust accordingly. If you are doing it manually then we should be able to whip something up for you.

[Leith Ross]

Hello Gti182,

Do you mean you want to increment the version name whenever the csv file is saved from Excel?

[Gti182]

I'm doing it all manually at the minute.

@Leith Ross: Yes Each .csv file saved needs to be saved in numerical order i.e. v1, v2, v3 etc

[Leith Ross]

Hello Gti182,

This macro will save the current workbook as a csv file with the appropriate version number. The next question is how should we trigger the macro?

Please Login or Register  to view this content.

[Gti182]

Thanks Leith that works a treat! I see it renames the original excel file though, is there a way to keep the filename the same as before?

[Leith Ross]

Hello Gti182,

This will not rename the original workbook. Since this is a CSV file, Excel will only save the Active Sheet as the CSV file.

Please Login or Register  to view this content.

[Gti182]

awesome, got it to work perfectly. Thanks for the quick code, u a machine!

[Gti182]

Hi All,

I'm not sure what happened with my code but all was working fine before i added some code to change formatting

The macro runs through fine but it saves the csv file to my desktop and not the original save location of the excel producing the csv file?

Can anyone see where i'm going wrong?

Please Login or Register  to view this content.

[Gti182]

anyone?

[Gti182]

gaaah this is driving me mad! Why is the csv file saving to my desktop???? grrrrr

I'll do some more fiddling...

[Gti182]

to the top, still no luck

[Gti182]

bump bump