Hi All,

I have a tough one for you here;

I need to be able to run an excel macro with a fixed name in an open .xls with a variable name.

I do not want to have to specify .xls name or path in .vbs script. There will only be one instance of this macro name available at any one time.

Any ideas?