Active Workbook Name To Call a Macro

[alexaronson]

Hello and thank you for your help

I have the following code that calls a macro for me.

Application.Run "Test.xlsm'!NamShortList"

One of the problems I am runnign into is that my users are changing the file name. So I thought about changing the file name to a variable with the following code

Dim WbName As Variant
WbName = ActiveWorkbook.Name

I am trying to replace the Test.xlsm piece of the original code with WbName. However I can't seem to get the macro to fire off.

Any suggestions?
Thanks

 

[Norie]

What if the problem is in one of the subs that could get called?

It might not even be an error.