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@...

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

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.)

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.)

Automatic execution of a Macro. Can be set up using the Visual Basic Editor

1. Open the Work Book and Open Visual basic editor. In the Project Explorer
window, expand the desired workbooks VBA Project object by clicking the plus
sign (+) next to the objects icon.

2. Right click the This WorkBook object and select View Code. each object
has an associated module. This step opens the Module of the This Workbook
object

At the top of the browser under "Insert" Insert procedure (WorkBook-Open)
Save and close the work book and reopen it to test it .

Be sure to create a copy to test on before trying this!!!

Don Kollmann
Donk@...
Data analysis

-----Original Message-----
From: Charles Metcalf [mailto:chuck_metcalf@...]
Sent: Tuesday, November 07, 2000 2:36 PM
To: vantage@egroups.com
Subject: [Vantage] Off Subject

Does anyone know how to automate macros so they run when you open an
Excel Workbook.
Thanks
Chuck