Run Excel-Macro when the Excelworkbook is open

[Jens Steichert]

Hi there,

i wrote a script in an outlook user form. This script starts an Excel-Macro.
Before it starts the macro, the script checks if the wished workbook is
open. When it's closed the scripts starts excel and runs the macro. But the
workbook is open, the script opens the workbook again. The script should use
the current open Workbook. How can i make that?

Thanks for your help
Jens

P.S. Sorry about my English. It isn't very well

 

[Sue Mosher [MVP]]

Show the code you're using to check wehther the workbook is already open.