Run a macron in a workbook that is NOT open (Excel 97/2002)

Topic

New Reply

Is it possible to run a macro that is saved in a workbook that you do NOT have open?

Reply | Quote

Replies

No way that I know of.

Reply | Quote

Depends on what you want. You can call a macro in another workbook, but then Excel will load the workbook when you do the call.

Reply | Quote

I know how to load the workbook with the macro in it, but I don’t want the sheets in that WB to be seen.

I just want it in the background.

Reply | Quote

Try something like this:

Dim wbk As Workbook
Application.ScreenUpdating = False
Set wbk = Workbooks.Open(“C:ExcelTest.xls”)
ActiveWindow.Visible = False
Application.ScreenUpdating = True

Of course, you must substitute the appropriate path and file name.

Reply | Quote