Workbooks("Test").Activate -> error : Subscribe out of range

[ctudose]

Hi everyone,

Plz,give me an hint.
I've written an application in VBA
On my machive it works ok.If i run the application on other machine I got the following error:

Run-time error 9
Subscribe out of range

in the following line :
Workbooks("Test&quot.Activate , where Test.xls is the name of the Excel file,that holds the macro.
I name is correct...
Plz. help !!
Thanks

 

[ctudose]

I've added on the machine that ran the macro the following library : Microsoft VB for Applications Extensibility
It worked.
But,can anyone explain way if I remove back MS VBA Extensibility lib, the macro still runs properly?

Thanks in advance
Cris

 

[bryanbayfield]

Instead of using Workbooks("Test&quot use ThisWorkbook