Calling macro in another workbook

Hi,

i currently have workbook1 that runs some macros. When the last macro is done, i want to be able to open another workbook (workbook2) and run a macro on that workbook. Also i want to close workbook1, if possible.

Anyone ever tried this before?

thanks
scott

You can open the other workbook and call a macro in it.
However in my experience once you close the first workbook it will kill any macros that were called from it, i.e. the macro you started running in the second workbook.

An option may be to use the Workbook_Open event handler in the second workbook close the first and then run the desired macro. This however will always run when the second workbook is opened regardless of if it is opened from the first workbooks macros or opened manually.

HTH