Run a macro from workbook then close workbook and let the macro open it again?

[Erik83]

Hi,

I'm trying to do exactly what's in the title. I'm assuming there must be a sub that can continue to function when I close the workbook it exists in and was run in?

Thanks for any help

Best regards

Erik

 

[RoryA]

How exactly would it do that? More to the point, why do you need to do that? The nearest equivalent I can think of is to use Application.Ontime to scehdule the macro to run, then close the workbook. As long as the session of Excel is not closed down, at the due time, the workbook will be reopened so that the macro can run.

 

[westconn1]

I'm assuming there must be a sub that can continue to function

no subs will run in the workbook that closes, the sub containing the close statement will not complete

to do what you want you would have to have a new workbook running or an addin, and have the code running in that workbook to close the other workbook, else write out a vbs script file then shell it from your code before closing the workbook

there is probably some other way to do what you want, depending why you are wanting to do it