MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Automatically executing a macro when opening Excel


Posted by Bob Polk on October 30, 2001 4:40 AM


I have two questions:

1. Is there a way to have a macro automatically execute when you open the worksheet that it is in? If so, I would appreciate it if you would share the code.

2. Is it possible to write a macro in MS Outlook to automatically export the mail messages in a certain folder and save it to a *.txt file on the hard drive?

Thanks,

Bob Polk
polkrt@yahoo.com


Posted by conor on October 30, 2001 4:52 AM


--->name the macro Auto_Open and it will be executed on opening the worksheet.


-->not sure