I am trying put a macro into the personal.xls file so
that it loads whenever I open a new workbook. I have
made all of the subroutines & functions public, but it
doesn't seem to be working - are there any tricks to make
the new workbook recognize the macro. Thanks in advance
for the help.

Chris.

To call a macro in another workbook, you would use

Application.Run "Personal.xls!MyMacro",arg1, arg2

as an example.

--
Regards,
Tom Ogilvy

"Chris" wrote in message
...
I am trying put a macro into the personal.xls file so
that it loads whenever I open a new workbook. I have
made all of the subroutines & functions public, but it
doesn't seem to be working - are there any tricks to make
the new workbook recognize the macro. Thanks in advance
for the help.

Chris.

Tom,
Thanks for the help, but it didn't solve my problem. I
am using a command button in Excel (new workbook) to open
the macro (well VB script really) in personal.xls. Here
is the command button statement right now:

Private Sub CommandButton1_Click()
Call SFileOpen 'name of subroutine in personal.xls
End Sub

Once again any help is greatly appreciated.

Chris.
-----Original Message-----
To call a macro in another workbook, you would use

Application.Run "Personal.xls!MyMacro",arg1, arg2

as an example.

--
Regards,
Tom Ogilvy

"Chris" wrote in message
...
I am trying put a macro into the personal.xls file so
that it loads whenever I open a new workbook. I have
made all of the subroutines & functions public, but it
doesn't seem to be working - are there any tricks to
make
the new workbook recognize the macro. Thanks in
advance
for the help.

Chris.


.

I gave you the answer. Call won't work unless you set a reference from the
sheet with the button to the personal.xls file which is generally not
something you want to do.


Private Sub CommandButton1_Click()
Application.Run "Personal.xls!SFileOpen" 'name of subroutine in
personal.xls
End Sub

--
Regards,
Tom Ogilvy



"Chris" wrote in message
...
Tom,
Thanks for the help, but it didn't solve my problem. I
am using a command button in Excel (new workbook) to open
the macro (well VB script really) in personal.xls. Here
is the command button statement right now:

Private Sub CommandButton1_Click()
Call SFileOpen 'name of subroutine in personal.xls
End Sub

Once again any help is greatly appreciated.

Chris.
-----Original Message-----
To call a macro in another workbook, you would use

Application.Run "Personal.xls!MyMacro",arg1, arg2

as an example.

--
Regards,
Tom Ogilvy

"Chris" wrote in message
...
I am trying put a macro into the personal.xls file so
that it loads whenever I open a new workbook. I have
made all of the subroutines & functions public, but it
doesn't seem to be working - are there any tricks to
make
the new workbook recognize the macro. Thanks in
advance
for the help.

Chris.


.