Macro that is unaffected by file name changes

Hi everyone!

So I have this macro that changes a completely illegible date format to a normal (in my case German one).
I am no good with VBA so I recorded it with the tool - and it works!
It uses a different macro I recorded within the macro, as seen in this line:

[...]
Application.Run "EvaluationWorkingCopy!englischer_Monat_zu_Zahl"
[...]

But the file is going to be copied and renamed a lot of times. For now the document is called "EvaluationWorkingCopy".

Now, my problem is this: If I rename the document, it can't run the big macro because the file name in the "englischer_Monat_zu_Zahl" macro didn't change. Is there a way to automatically change the name / store it in a variable that is getting called?

Thanks in advance.

Try

Please Login or Register  to view this content.