Excel97 : Automically open a Macro by opening a xls file 
Author Message
 Excel97 : Automically open a Macro by opening a xls file

Can anybody tell us how we can start automatically a macro in Excel97
when a xls files is opened by a user ?

Thanks.



Sun, 30 Dec 2001 03:00:00 GMT  
 Excel97 : Automically open a Macro by opening a xls file
Use Workbook_Open() or if it should be compatible with Excel 95 use
Auto_Open().
Here is a tip: open the workbook you're working on, start visual basic
editor (alt+f11), doubleclick on the workbook on the left side on the
screen. The place where it says 'General' (a roll down menu) select
Workbook, the menu to the right of this one, now shows 'all' available
rutines/events that react on the workbook object - and indeed also the Open
rutine.

Casper S. Jensen

Quote:

>Can anybody tell us how we can start automatically a macro in Excel97
>when a xls files is opened by a user ?

>Thanks.



Sun, 30 Dec 2001 03:00:00 GMT  
 Excel97 : Automically open a Macro by opening a xls file
Press altF11 to open up the visual basic editor.  Find the file you want to
add the AutoOpen routine to.  Click on ThisWorkbook under Microsoft Excel
Objects.  Pull down Workbook where it says General.  This should create a
routine that will automatically run when the file is opened.
Quote:

> Can anybody tell us how we can start automatically a macro in Excel97
> when a xls files is opened by a user ?

> Thanks.



Thu, 03 Jan 2002 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Jpeg files open automically when message is opened.

2. Stop opening book1.xls/keep task pane open when starting Excel (personal.xls issue)

3. Excel97 opens blank file when opening an excel spreadsheet

4. Excel97 opens blank file when opening an excel spreadsheet

5. Open XLS attachment says file already open

6. Opening XLS attachments in OUTLOOK 2000 - Says file is already open

7. Book1.xls opens when I open an excel file on my H.D.

8. Help Excel97 macro to run on file open or close

9. Open specific *.xls file using macro

10. How to disable the macro in an Excel xls file when use workbook.open


 
Powered by phpBB® Forum Software © phpBB Group