Change comment in VBA module when workbook opens

[Phil Smith]

Hi everyone.

Is it possible to change a comment line within a module to use a variable?

I have a comment in one of my workbooks that is "Working on this project 2008-2010".

If it is possible, when the workbook is opened, I would like the comment line to be changed so that it takes into account Year(Now) instead of showing a static "2010".

I would take a guess that it is not possible, but am prepared to be stunned by the expertise of the board members.

Thanks.

Phil

 

[kpark91]

Perhaps this whole page may help lol

http://www.cpearson.com/excel/vbe.aspx

 

[Phil Smith]

Thanks for the reply.

Looked at that page and I sensed I would be getting in WAY over my head.

Guess I will just have to remember to change it manually as & when I need to!

Thanks for the prompt reply though!

 

[mikerickson]

Wouldn't the built in Document Property "Modified on" do what you want?

 

[Phil Smith]

Forgive my ignorance; How would I use that property?

 

[mikerickson]

Click on the File tab. On the right of that screen there are Properties listed, including Last Modified, which is the date/time that the file was last saved.

If it is possible, when the workbook is opened, I would like the comment line to be changed so that it takes into account Year(Now) instead of showing a static "2010".

It sounds like that is the value that you want "saved" in the VB module comment.

 

[Phil Smith]

And is it possible to "save" that information to a comment line within a module? And all I need is the current year as I said in my first post.

Thanks.

 

[mikerickson]

My point is that that value is automaticaly saved with the workbook. There is no need to save it to a comment in a module, its already saved to the Last Modified property.

Especially since modifying the comments in a code module requries a certain level of Trust Access.

 

[Phil Smith]

Thanks for explaining.