Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel application object | Excel Programming | |||
creating Excel Application Object in C#? | Excel Programming | |||
Excel Automation Add-In, Accessing the application object | Excel Programming | |||
"Excel.Application" Object Model | Charts and Charting in Excel | |||
Problem on the ASP using the Excel.Application Object | Excel Programming |