macros in excel application object
 

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

macros in excel application object
 

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" wrote in message
oups.com...
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

macros in excel application object
 

Hi,

is there a posibility for a macro outside the workbook?

Thx, Josef


Bob Phillips wrote:
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" wrote in message
oups.com...
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

macros in excel application object
 

You could use Application.Run

Application.Run "myBook.xls!test_msgbox"

--
HTH

Bob Phillips

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

"josef123" wrote in message
oups.com...
Hi,

is there a posibility for a macro outside the workbook?

Thx, Josef


Bob Phillips wrote:
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" wrote in message
oups.com...
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