How to do automatic increment the number

[Au4848]

Hi Folks,

I have directory called Filename:="D:Daily 8A MWINTDATA2002Mar02INT03102002".would anyone help me in code form how to increment INT03102002 to INT03112002 next INT03122002 automatically like this it has to increment upto number ofdays in the month.

Your help is highhly appreciated.

[Juan Pablo González]

When are you incrementing this number ? when saving ? when something specific happens ? each day ?

[zacemmel]

Do you want the filename to represent the current month, day, year or just increment the previous number?

[Juan Pablo González]

I think the name is something like

INTmmddyyyy

where mmddyyyy is the date in that date format (Month - Day - Year)

[Au4848]

I just want to increment mm/dd/yyyy format whenever the spread sheet is saved.

[Au4848]

I want to file to represent next day say for example to 03/22/2002 it should be increment to next day for next saving the spreadsheet