new to VBA
 

Just wrote my first VBA program now my question is: how do I save the code
so that it is available as a macro anytime I run Excel?
thanks
nick

new to VBA
 

Nick,

In order to have it available when you open Excel it'll have to
placed in your Personal.xls file.
Check the VBA Editor under the "Project" and see if it exists.
If not, go back to Excel and record a macro (any macro) and when
asked where to save it, choose "Personal.xls" (now you'll be able
to copy/move your macro into the Personal.xls).

For some more help with this, take a look he
http://www.mvps.org/dmcritchie/excel/getstarted.htm

John

"Mimmo" wrote in message
.. .
Just wrote my first VBA program now my question is: how do I save the code
so that it is available as a macro anytime I run Excel?
thanks
nick

new to VBA
 

Actually it doesn't have to be in a file named Personal.xls. It just has to be in an XLS file
that you save in your XLSTART folder so it is loaded every time Excel starts up.


On Sun, 24 Aug 2003 20:57:42 -0400, "John Wilson" wrote:

Nick,

In order to have it available when you open Excel it'll have to
placed in your Personal.xls file.
Check the VBA Editor under the "Project" and see if it exists.
If not, go back to Excel and record a macro (any macro) and when
asked where to save it, choose "Personal.xls" (now you'll be able
to copy/move your macro into the Personal.xls).

For some more help with this, take a look he
http://www.mvps.org/dmcritchie/excel/getstarted.htm

John

"Mimmo" wrote in message
. ..
Just wrote my first VBA program now my question is: how do I save the code
so that it is available as a macro anytime I run Excel?
thanks
nick

new to VBA
 

Myrna,

Actually it doesn't have to be in a file named Personal.xls
Quite true. I guess the critical phrase in my reply was "have to be".
Better stated could have been "one easy way to do it would be".
I'll remember that in future posts.
Guess I was just looking at the "new to VBA" and didn't want to
complicate things.

John




"Myrna Larson" wrote in message
...
Actually it doesn't have to be in a file named Personal.xls. It just has
to be in an XLS file
that you save in your XLSTART folder so it is loaded every time Excel
starts up.


On Sun, 24 Aug 2003 20:57:42 -0400, "John Wilson"
wrote:

Nick,

In order to have it available when you open Excel it'll have to
placed in your Personal.xls file.
Check the VBA Editor under the "Project" and see if it exists.
If not, go back to Excel and record a macro (any macro) and when
asked where to save it, choose "Personal.xls" (now you'll be able
to copy/move your macro into the Personal.xls).

For some more help with this, take a look he
http://www.mvps.org/dmcritchie/excel/getstarted.htm

John

"Mimmo" wrote in message
. ..
Just wrote my first VBA program now my question is: how do I save the
code
so that it is available as a macro anytime I run Excel?
thanks
nick

new to VBA
 

Myrna, that is a subtly useful idea. Since you mentioned it, I'm
inspired to split up my personal.xls, which over time bas built up to
dozens of subs and functions.

One side benefit is that I can shed the ones that are nothing but
"noise" to office colleagues (but that I myself could never part with
<g), and pass around a concise version that they would easily
comprehend and thus find palatable.

On Sun, 24 Aug 2003 20:45:02 -0500, Myrna Larson
wrote:

Actually it doesn't have to be in a file named Personal.xls. It just has to be in an XLS file
that you save in your XLSTART folder so it is loaded every time Excel starts up.


On Sun, 24 Aug 2003 20:57:42 -0400, "John Wilson" wrote:

Nick,

In order to have it available when you open Excel it'll have to
placed in your Personal.xls file.
Check the VBA Editor under the "Project" and see if it exists.
If not, go back to Excel and record a macro (any macro) and when
asked where to save it, choose "Personal.xls" (now you'll be able
to copy/move your macro into the Personal.xls).

For some more help with this, take a look he
http://www.mvps.org/dmcritchie/excel/getstarted.htm

John

"Mimmo" wrote in message
...
Just wrote my first VBA program now my question is: how do I save the code
so that it is available as a macro anytime I run Excel?
thanks
nick

new to VBA
 

thanks to all
"Wild Bill" wrote in message
...
Myrna, that is a subtly useful idea. Since you mentioned it, I'm
inspired to split up my personal.xls, which over time bas built up to
dozens of subs and functions.

One side benefit is that I can shed the ones that are nothing but
"noise" to office colleagues (but that I myself could never part with
<g), and pass around a concise version that they would easily
comprehend and thus find palatable.

On Sun, 24 Aug 2003 20:45:02 -0500, Myrna Larson
wrote:

Actually it doesn't have to be in a file named Personal.xls. It just has
to be in an XLS file
that you save in your XLSTART folder so it is loaded every time Excel
starts up.


On Sun, 24 Aug 2003 20:57:42 -0400, "John Wilson"
wrote:

Nick,

In order to have it available when you open Excel it'll have to
placed in your Personal.xls file.
Check the VBA Editor under the "Project" and see if it exists.
If not, go back to Excel and record a macro (any macro) and when
asked where to save it, choose "Personal.xls" (now you'll be able
to copy/move your macro into the Personal.xls).

For some more help with this, take a look he
http://www.mvps.org/dmcritchie/excel/getstarted.htm

John

"Mimmo" wrote in message
...
Just wrote my first VBA program now my question is: how do I save the
code
so that it is available as a macro anytime I run Excel?
thanks
nick

new to VBA
 

"Myrna Larson" wrote in message
...
Actually it doesn't have to be in a file named Personal.xls. It just has
to be in an XLS file
that you save in your XLSTART folder so it is loaded every time Excel
starts up.

Hi Myrna,

There's one subtle difference between a hidden workbook named
personal.xls and one named anything else. If a hidden workbook in the
XLStart directory is named anything other than personal.xls, Excel will
start without automatically creating a new empty template workbook. Excel
recognizes the name "personal.xls" as a special case and it will create the
template workbook in addition to opening a workbook by this name from
XLStart.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *

new to VBA
 

Rob,

So my original post was only 99% wrong??? <vbg

John

P.S. Apologies that I sent the first reply directly to you. Recently
switched
from Netscape to OE and still getting used to it.


"Rob Bovey" wrote in message
...
"Myrna Larson" wrote in message
...
Actually it doesn't have to be in a file named Personal.xls. It just has
to be in an XLS file
that you save in your XLSTART folder so it is loaded every time Excel
starts up.

Hi Myrna,

There's one subtle difference between a hidden workbook named
personal.xls and one named anything else. If a hidden workbook in the
XLStart directory is named anything other than personal.xls, Excel will
start without automatically creating a new empty template workbook. Excel
recognizes the name "personal.xls" as a special case and it will create
the
template workbook in addition to opening a workbook by this name from
XLStart.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *