macros in excel application object

[josef123]

Hi,

is there a possibility that excel macros are always executed, even if
excel is used as application object called from another application?
(Are macros in XLStart executed if excel is used as application
object.)

Thx, josef

 

[Bob Phillips]

Use workbook_open code in the workbook being opened.

Private Sub Workbook_Open()
End Sub

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[josef123]

Hi,

is there a posibility for a macro outside the workbook?

Thx, Josef

 

[Bob Phillips]

You could use Application.Run

Application.Run "myBook.xls!test_msgbox"

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)