Run xls Macro

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?

Thanks,

W