is there way run macro is existed in colsed file and run for open file

[Alaa mg]

hi experts
I have two files when open the file I would call the macro from closed the file without open it . the two files are existed in the same folder
thanks

 

[StephenCrump]

You can't run VBA code from a workbook that isn't open.

Why do you want to do this, i.e. why don't you want to open the second workbook?

 

[Alaa mg]

thanks
ok . even copy the macro from closed file to open file is not possible?

 

[StephenCrump]

thanks
ok . even copy the macro from closed file to open file is not possible?

No, not possible.

But there are other options, e.g.
- open the workbook and run the code
- open the workbook and copy the code to your current workbook
- put the code in a personal workbook or add-in.