You can save the worksheet as an Excel Add-In (.xla) and save it in your
c:\program files\Microsoft Office\Office\xlStart directory.
I looked this up in the help so here is something else to try.
RunAutoMacros Method Example
This example opens the workbook Analysis.xls and then runs its Auto_Open
macro.
Workbooks.Open "ANALYSIS.XLS"
ActiveWorkbook.RunAutoMacros xlAutoOpen
This example runs the Auto_Close macro for the active workbook and then
closes the workbook.
With ActiveWorkbook
.RunAutoMacros xlAutoClose
.Close
End With
Hope this helps,
Ted Kitch
tedkitch@...
c:\program files\Microsoft Office\Office\xlStart directory.
I looked this up in the help so here is something else to try.
RunAutoMacros Method Example
This example opens the workbook Analysis.xls and then runs its Auto_Open
macro.
Workbooks.Open "ANALYSIS.XLS"
ActiveWorkbook.RunAutoMacros xlAutoOpen
This example runs the Auto_Close macro for the active workbook and then
closes the workbook.
With ActiveWorkbook
.RunAutoMacros xlAutoClose
.Close
End With
Hope this helps,
Ted Kitch
tedkitch@...
On Tue, 7 Nov 2000 15:36:28 -0600, vantage@egroups.com wrote:
> For some reason, this did not work
>
> -----Original Message-----
> From: calvin [mailto:calvin@...]
> Sent: Tuesday, November 07, 2000 3:08 PM
> To: vantage@egroups.com
> Subject: Re: [Vantage] Off Subject
>
>
> Chuck -
>
> Name your Excel macro 'autoexec'
> this will run when the spreadsheet loads.
>
> GTH,
> Calvin
>
> ----- Original Message -----
> From: Charles Metcalf <chuck_metcalf@...>
> To: <vantage@egroups.com>
> Sent: Tuesday, November 07, 2000 2:35 PM
> Subject: [Vantage] Off Subject
>
>
> > Does anyone know how to automate macros so they run when you open an
> > Excel Workbook.
> > Thanks
> > Chuck
> >
> >
> >
> > We no longer allow attachments to files. To access/share Report Files,
> please go to the following link: http://www.egroups.com/files/vantage/
> > (Note: If this link does not work for you the first time you try it,
go
> to www.egroups.com, login and be sure to save your password, choose My
> Groups, choose Vantage, then choose Files. If you save the password, the
> link above will work the next time you try it.)
>
>
> We no longer allow attachments to files. To access/share Report Files,
> please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go
to
> www.egroups.com, login and be sure to save your password, choose My
Groups,
> choose Vantage, then choose Files. If you save the password, the link
above
> will work the next time you try it.)
>
Ted Kitch
tedkitch@...
_______________________________________________________
Say Bye to Slow Internet!
http://www.home.com/xinbox/signup.html