Tracking filename changes

[RodrigoTomaz]

Hi,
I already (unsuccessfully) searched for a way to track filename events, in order to trigger a macro (i.e. when a already document is opened, and then, saved with a new name).
Is there a way to accomplish this?

[JBeaucaire]

How would you like this "tracking" to function, outside the obvious if the current filename is changed to something new, trigger this macro... once triggered, what exactly is supposed to happen?

[RodrigoTomaz]

Hi JBeaucaire,

Initially, for testing purposes I just want to display the MsgBox.

[JBeaucaire]

Put all of this code into the ThisWorkbook module, save, close, reopen, save with new name...

Please Login or Register  to view this content.

[RodrigoTomaz]

Thank you. I did as you said, but when saving (and renaming) the file, there's no action...
I need to create an Excel addin (xlam) in order to use it as a template. In this case, shall I put the code on a module (I'm really newbie on it)?

[JBeaucaire]

An Addin won't work. That is level of complexity greater than I can assist on.

Here's my sample workbook and it is showing the popup messages...

[RodrigoTomaz]

Thank you again.

[romperstomper]

For an add-in you need application-level events. At its simplest:

In the ThisWorkbook module of your add-in:

Please Login or Register  to view this content.