Incrementing a cell on opening a workbook!

[Steve_B]

Hi All

I am sure that this question has been answered before and I would be grateful if someone could point me in the right direction.

I want to have a workbook that will increment a value in say A1 by 1 each time it opens, this value needs to be recorded even if the workbook is saved under another name.

First time A1 = 1
Second time A1 = 2
Etc, etc

 

[Steve_B]

Sorry all but I must be totally missing the point I can't get either to work.

 

[just_jon]

Hi Smitty - I didn't want to specify any sheet names either since I figured that if people might change the name of the workbook, they might change the name of the tab as well - not that that makes my code free from problems either...

Instead of the sheet name, use the sheet's CodeName, or its Index number.

 

[Steve_B]

I should have checked where I put the code!

Both options work great

I would like to know if this increment in the cell can now be saved or remembered even if I don't save the workbook?

 

[just_jon]

Not in the way we've been going.

You'd have to increment a value in ANOTHER file and save that file, in your on-open macro, to do that I think.

 

[tmischler]

that's kind of what I was wondering too - so there's no other way of declaring a variable that makes it last longer than static?

 

[just_jon]

Well, no.

BUT -- in your on-open, why not 1] increment the cell, then 2] do an immediate save of the file?

 

[Steve_B]

Thanks just_jon,

Sounds like a good idea will take a look at it!