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

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