callbyname in XL 2K and XL 2003
 

Hey there,

I have a sub called "test" in the ThisWorkbook module of an addin. In the
Immediate window I enter:

CallByName workbooks("fb tester.xla"), "test", VbMethod

In XL 2003 the macro runs, but in XL 2k it does not.

Can anybody tell me how to make this work in XL 2000?

Thanks,

Doug Glancy

callbyname in XL 2K and XL 2003
 

The answer is that things work better when you compile - something I thought
I'd already learned!

Thanks anyways,

Doug

"Doug Glancy" wrote in message
...
Hey there,

I have a sub called "test" in the ThisWorkbook module of an addin. In the
Immediate window I enter:

CallByName workbooks("fb tester.xla"), "test", VbMethod

In XL 2003 the macro runs, but in XL 2k it does not.

Can anybody tell me how to make this work in XL 2000?

Thanks,

Doug Glancy