Hi,

I have an excel macro which is running good.

I want to get the file name of the other excel file which is open already and to get activate.
This is what I want as an extension to already existing macro.

Ex: SLA.xlsm is the file in which macro already exists.
ABC.xls is the file which is already open. (ABC.xls may change sometimes, the name is just for an example and always the name changes from ABC to any thing).

Now While I am running the macro iin SLA.xlsm at some stage it should get the filename ABC.xls and ABC.xls to be activate.

I hope I am clear.

Is it possible..?