Macros - copying macros from one computer to another
 

I have created a whole bunch of macros on my work computer. How do I copy
all these macros to my home computer??

Macros - copying macros from one computer to another
 

If the macros reside in an Excel file, just email it........

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

I have created a whole bunch of macros on my work computer. How do I copy
all these macros to my home computer??

Macros - copying macros from one computer to another
 

The problem is I have no idea where the macros are saved. The macros I
created are not custom macros (I'm only a beginner in macros, and I only know
how to create macros using the "record macro" function, and then assigning
them to a button), so I don't know where this type of macros are saved, or
how they are saved.

"CLR" wrote:

If the macros reside in an Excel file, just email it........

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

I have created a whole bunch of macros on my work computer. How do I copy
all these macros to my home computer??

Macros - copying macros from one computer to another
 

Macros that are recorded are stored in the same file that you recorded them
in. When you save that file, you save the macros therein. Just email that
file home and the macros will be there when you open it.

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

The problem is I have no idea where the macros are saved. The macros I
created are not custom macros (I'm only a beginner in macros, and I only know
how to create macros using the "record macro" function, and then assigning
them to a button), so I don't know where this type of macros are saved, or
how they are saved.

"CLR" wrote:

If the macros reside in an Excel file, just email it........

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

I have created a whole bunch of macros on my work computer. How do I copy
all these macros to my home computer??

Macros - copying macros from one computer to another
 

When I created the macros, I didn't save them in a particular file. Instead,
I saved them in my personal.xls, which can then be applied to all the files I
open using the application.

I know for sure these macros are not associated with the file because if I
open the file in someone else's computer, there's no macros buttons on their
excel application.

"CLR" wrote:

Macros that are recorded are stored in the same file that you recorded them
in. When you save that file, you save the macros therein. Just email that
file home and the macros will be there when you open it.

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

The problem is I have no idea where the macros are saved. The macros I
created are not custom macros (I'm only a beginner in macros, and I only know
how to create macros using the "record macro" function, and then assigning
them to a button), so I don't know where this type of macros are saved, or
how they are saved.

"CLR" wrote:

If the macros reside in an Excel file, just email it........

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

I have created a whole bunch of macros on my work computer. How do I copy
all these macros to my home computer??

Macros - copying macros from one computer to another
 

Email the personal.xls file home. You can find it by doing Start Search
For files and folders in Windows Explorer........you may have to re-create
the buttons at home but you'll have the macros.

Vaya con Dios,
Chuck, CABGx3





"TT" wrote:

When I created the macros, I didn't save them in a particular file. Instead,
I saved them in my personal.xls, which can then be applied to all the files I
open using the application.

I know for sure these macros are not associated with the file because if I
open the file in someone else's computer, there's no macros buttons on their
excel application.

"CLR" wrote:

Macros that are recorded are stored in the same file that you recorded them
in. When you save that file, you save the macros therein. Just email that
file home and the macros will be there when you open it.

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

The problem is I have no idea where the macros are saved. The macros I
created are not custom macros (I'm only a beginner in macros, and I only know
how to create macros using the "record macro" function, and then assigning
them to a button), so I don't know where this type of macros are saved, or
how they are saved.

"CLR" wrote:

If the macros reside in an Excel file, just email it........

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

I have created a whole bunch of macros on my work computer. How do I copy
all these macros to my home computer??

Macros - copying macros from one computer to another
 

I see. Thank you very much. Now I understand. I'll try it and let you know
if it works.

"CLR" wrote:

Email the personal.xls file home. You can find it by doing Start Search
For files and folders in Windows Explorer........you may have to re-create
the buttons at home but you'll have the macros.

Vaya con Dios,
Chuck, CABGx3





"TT" wrote:

When I created the macros, I didn't save them in a particular file. Instead,
I saved them in my personal.xls, which can then be applied to all the files I
open using the application.

I know for sure these macros are not associated with the file because if I
open the file in someone else's computer, there's no macros buttons on their
excel application.

"CLR" wrote:

Macros that are recorded are stored in the same file that you recorded them
in. When you save that file, you save the macros therein. Just email that
file home and the macros will be there when you open it.

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

The problem is I have no idea where the macros are saved. The macros I
created are not custom macros (I'm only a beginner in macros, and I only know
how to create macros using the "record macro" function, and then assigning
them to a button), so I don't know where this type of macros are saved, or
how they are saved.

"CLR" wrote:

If the macros reside in an Excel file, just email it........

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

I have created a whole bunch of macros on my work computer. How do I copy
all these macros to my home computer??

Macros - copying macros from one computer to another
 

You're welcome.......I keep my personal.xls file on a pocket Jump Drive and
take it wherever I go..........

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

I see. Thank you very much. Now I understand. I'll try it and let you know
if it works.

"CLR" wrote:

Email the personal.xls file home. You can find it by doing Start Search
For files and folders in Windows Explorer........you may have to re-create
the buttons at home but you'll have the macros.

Vaya con Dios,
Chuck, CABGx3





"TT" wrote:

When I created the macros, I didn't save them in a particular file. Instead,
I saved them in my personal.xls, which can then be applied to all the files I
open using the application.

I know for sure these macros are not associated with the file because if I
open the file in someone else's computer, there's no macros buttons on their
excel application.

"CLR" wrote:

Macros that are recorded are stored in the same file that you recorded them
in. When you save that file, you save the macros therein. Just email that
file home and the macros will be there when you open it.

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

The problem is I have no idea where the macros are saved. The macros I
created are not custom macros (I'm only a beginner in macros, and I only know
how to create macros using the "record macro" function, and then assigning
them to a button), so I don't know where this type of macros are saved, or
how they are saved.

"CLR" wrote:

If the macros reside in an Excel file, just email it........

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

I have created a whole bunch of macros on my work computer. How do I copy
all these macros to my home computer??

Macros - copying macros from one computer to another
 

Sending Personal.xls home will get your macros home but if you have made a
custom toolbar with buttons to run the macros, they will not be available on
your home computer.

Customizations to Menus and Toolbars are saved in your Excelxx.XLB file.

If only a customized Toolbar, you could attach it to Personal.xls.

Otherwise you could send the Excelxx.XLB file home also and overwrite your
current one on home computer.

This is not always desirable.

Best method of assigning macros to buttons is to build the Toolbar when you open
the workbook and delete it when you close.

Do not make the changes to the existing toolbars.

See Debra Dalgleish's website for Dave Peterson help on building "on the fly"
toolbars and menus.

http://www.contextures.on.ca/xlToolbar02.html


Gord Dibben MS Excel MVP



On Fri, 8 Dec 2006 07:51:00 -0800, TT wrote:

I see. Thank you very much. Now I understand. I'll try it and let you know
if it works.

"CLR" wrote:

Email the personal.xls file home. You can find it by doing Start Search
For files and folders in Windows Explorer........you may have to re-create
the buttons at home but you'll have the macros.

Vaya con Dios,
Chuck, CABGx3





"TT" wrote:

When I created the macros, I didn't save them in a particular file. Instead,
I saved them in my personal.xls, which can then be applied to all the files I
open using the application.

I know for sure these macros are not associated with the file because if I
open the file in someone else's computer, there's no macros buttons on their
excel application.

"CLR" wrote:

Macros that are recorded are stored in the same file that you recorded them
in. When you save that file, you save the macros therein. Just email that
file home and the macros will be there when you open it.

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

The problem is I have no idea where the macros are saved. The macros I
created are not custom macros (I'm only a beginner in macros, and I only know
how to create macros using the "record macro" function, and then assigning
them to a button), so I don't know where this type of macros are saved, or
how they are saved.

"CLR" wrote:

If the macros reside in an Excel file, just email it........

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

I have created a whole bunch of macros on my work computer. How do I copy
all these macros to my home computer??

Gord Dibben MS Excel MVP

Macros - copying macros from one computer to another
 

Thank you Gord for your reply as well. But I can't seem to find the
personal.xls or the Excelxx.XLB file anywhere in my computer. I tried doing
a search on all my directories, and they are nowhere to be found. Are they
hidden files or in hidden folders?? When the search is running, it does say
that the search is not looking in hidden folders or hidden files.

Another question is, if I succeed in creating a customized toolbar, as
outlined in your instructions, does that mean I don't have to email the
personal.xls file as well? Or do I have to do both steps?

"Gord Dibben" wrote:

Sending Personal.xls home will get your macros home but if you have made a
custom toolbar with buttons to run the macros, they will not be available on
your home computer.

Customizations to Menus and Toolbars are saved in your Excelxx.XLB file.

If only a customized Toolbar, you could attach it to Personal.xls.

Otherwise you could send the Excelxx.XLB file home also and overwrite your
current one on home computer.

This is not always desirable.

Best method of assigning macros to buttons is to build the Toolbar when you open
the workbook and delete it when you close.

Do not make the changes to the existing toolbars.

See Debra Dalgleish's website for Dave Peterson help on building "on the fly"
toolbars and menus.

http://www.contextures.on.ca/xlToolbar02.html


Gord Dibben MS Excel MVP



On Fri, 8 Dec 2006 07:51:00 -0800, TT wrote:

I see. Thank you very much. Now I understand. I'll try it and let you know
if it works.

"CLR" wrote:

Email the personal.xls file home. You can find it by doing Start Search
For files and folders in Windows Explorer........you may have to re-create
the buttons at home but you'll have the macros.

Vaya con Dios,
Chuck, CABGx3





"TT" wrote:

When I created the macros, I didn't save them in a particular file. Instead,
I saved them in my personal.xls, which can then be applied to all the files I
open using the application.

I know for sure these macros are not associated with the file because if I
open the file in someone else's computer, there's no macros buttons on their
excel application.

"CLR" wrote:

Macros that are recorded are stored in the same file that you recorded them
in. When you save that file, you save the macros therein. Just email that
file home and the macros will be there when you open it.

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

The problem is I have no idea where the macros are saved. The macros I
created are not custom macros (I'm only a beginner in macros, and I only know
how to create macros using the "record macro" function, and then assigning
them to a button), so I don't know where this type of macros are saved, or
how they are saved.

"CLR" wrote:

If the macros reside in an Excel file, just email it........

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

I have created a whole bunch of macros on my work computer. How do I copy
all these macros to my home computer??

Gord Dibben MS Excel MVP

Macros - copying macros from one computer to another
 

TT

Open My Computer from Desktop and go to ToolsFolder OptionsView

Scroll down and check "show hidden folders and files"

Uncheck "hide extensions for known file types".

Now do your search................

Normal storage for *.xlb file is

C:\Documents and Settings\username\Application Data\Microsoft\Excel

For Personal.xls is

C:\Documents and Settings\Gord\Application Data\Microsoft\Excel\XLSTART

If you create a custom Toolbar per the code found at Debra's site, you will
still the macros that the customizations point to.

That's why I suggested Personal.xls to contain the macros and the workbook code
to create the Toolbar.


Gord


On Fri, 8 Dec 2006 11:16:02 -0800, TT wrote:

Thank you Gord for your reply as well. But I can't seem to find the
personal.xls or the Excelxx.XLB file anywhere in my computer. I tried doing
a search on all my directories, and they are nowhere to be found. Are they
hidden files or in hidden folders?? When the search is running, it does say
that the search is not looking in hidden folders or hidden files.

Another question is, if I succeed in creating a customized toolbar, as
outlined in your instructions, does that mean I don't have to email the
personal.xls file as well? Or do I have to do both steps?

"Gord Dibben" wrote:

Sending Personal.xls home will get your macros home but if you have made a
custom toolbar with buttons to run the macros, they will not be available on
your home computer.

Customizations to Menus and Toolbars are saved in your Excelxx.XLB file.

If only a customized Toolbar, you could attach it to Personal.xls.

Otherwise you could send the Excelxx.XLB file home also and overwrite your
current one on home computer.

This is not always desirable.

Best method of assigning macros to buttons is to build the Toolbar when you open
the workbook and delete it when you close.

Do not make the changes to the existing toolbars.

See Debra Dalgleish's website for Dave Peterson help on building "on the fly"
toolbars and menus.

http://www.contextures.on.ca/xlToolbar02.html


Gord Dibben MS Excel MVP



On Fri, 8 Dec 2006 07:51:00 -0800, TT wrote:

I see. Thank you very much. Now I understand. I'll try it and let you know
if it works.

"CLR" wrote:

Email the personal.xls file home. You can find it by doing Start Search
For files and folders in Windows Explorer........you may have to re-create
the buttons at home but you'll have the macros.

Vaya con Dios,
Chuck, CABGx3





"TT" wrote:

When I created the macros, I didn't save them in a particular file. Instead,
I saved them in my personal.xls, which can then be applied to all the files I
open using the application.

I know for sure these macros are not associated with the file because if I
open the file in someone else's computer, there's no macros buttons on their
excel application.

"CLR" wrote:

Macros that are recorded are stored in the same file that you recorded them
in. When you save that file, you save the macros therein. Just email that
file home and the macros will be there when you open it.

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

The problem is I have no idea where the macros are saved. The macros I
created are not custom macros (I'm only a beginner in macros, and I only know
how to create macros using the "record macro" function, and then assigning
them to a button), so I don't know where this type of macros are saved, or
how they are saved.

"CLR" wrote:

If the macros reside in an Excel file, just email it........

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

I have created a whole bunch of macros on my work computer. How do I copy
all these macros to my home computer??

Gord Dibben MS Excel MVP

Macros - copying macros from one computer to another
 

I see. Thank you very much for your quick response. I'll try it now.

"Gord Dibben" wrote:

TT

Open My Computer from Desktop and go to ToolsFolder OptionsView

Scroll down and check "show hidden folders and files"

Uncheck "hide extensions for known file types".

Now do your search................

Normal storage for *.xlb file is

C:\Documents and Settings\username\Application Data\Microsoft\Excel

For Personal.xls is

C:\Documents and Settings\Gord\Application Data\Microsoft\Excel\XLSTART

If you create a custom Toolbar per the code found at Debra's site, you will
still the macros that the customizations point to.

That's why I suggested Personal.xls to contain the macros and the workbook code
to create the Toolbar.


Gord


On Fri, 8 Dec 2006 11:16:02 -0800, TT wrote:

Thank you Gord for your reply as well. But I can't seem to find the
personal.xls or the Excelxx.XLB file anywhere in my computer. I tried doing
a search on all my directories, and they are nowhere to be found. Are they
hidden files or in hidden folders?? When the search is running, it does say
that the search is not looking in hidden folders or hidden files.

Another question is, if I succeed in creating a customized toolbar, as
outlined in your instructions, does that mean I don't have to email the
personal.xls file as well? Or do I have to do both steps?

"Gord Dibben" wrote:

Sending Personal.xls home will get your macros home but if you have made a
custom toolbar with buttons to run the macros, they will not be available on
your home computer.

Customizations to Menus and Toolbars are saved in your Excelxx.XLB file.

If only a customized Toolbar, you could attach it to Personal.xls.

Otherwise you could send the Excelxx.XLB file home also and overwrite your
current one on home computer.

This is not always desirable.

Best method of assigning macros to buttons is to build the Toolbar when you open
the workbook and delete it when you close.

Do not make the changes to the existing toolbars.

See Debra Dalgleish's website for Dave Peterson help on building "on the fly"
toolbars and menus.

http://www.contextures.on.ca/xlToolbar02.html


Gord Dibben MS Excel MVP



On Fri, 8 Dec 2006 07:51:00 -0800, TT wrote:

I see. Thank you very much. Now I understand. I'll try it and let you know
if it works.

"CLR" wrote:

Email the personal.xls file home. You can find it by doing Start Search
For files and folders in Windows Explorer........you may have to re-create
the buttons at home but you'll have the macros.

Vaya con Dios,
Chuck, CABGx3





"TT" wrote:

When I created the macros, I didn't save them in a particular file. Instead,
I saved them in my personal.xls, which can then be applied to all the files I
open using the application.

I know for sure these macros are not associated with the file because if I
open the file in someone else's computer, there's no macros buttons on their
excel application.

"CLR" wrote:

Macros that are recorded are stored in the same file that you recorded them
in. When you save that file, you save the macros therein. Just email that
file home and the macros will be there when you open it.

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

The problem is I have no idea where the macros are saved. The macros I
created are not custom macros (I'm only a beginner in macros, and I only know
how to create macros using the "record macro" function, and then assigning
them to a button), so I don't know where this type of macros are saved, or
how they are saved.

"CLR" wrote:

If the macros reside in an Excel file, just email it........

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

I have created a whole bunch of macros on my work computer. How do I copy
all these macros to my home computer??

Gord Dibben MS Excel MVP

Macros - copying macros from one computer to another
 

I did select & uncheck the options that you told me to do, I did manage to
find a XLB file, but I still can't find the Personal.xls file. What would I
be doing wrong?

If I have recorded any macros, I must have that file, correct? Would it be
possible that no such file exist in my computer? Can excel run without this
file? My excel is working fine.

Actually I'm running excel in a citrix environment, but I occasionally run
excel from my local machine, using excel application stored in my local
machine. I tried creating a macro in my local excel application, and
assigning it to a custom button, and then do the search for this Personal.xls
file, but I still can't find it. Please help.

"Gord Dibben" wrote:

TT

Open My Computer from Desktop and go to ToolsFolder OptionsView

Scroll down and check "show hidden folders and files"

Uncheck "hide extensions for known file types".

Now do your search................

Normal storage for *.xlb file is

C:\Documents and Settings\username\Application Data\Microsoft\Excel

For Personal.xls is

C:\Documents and Settings\Gord\Application Data\Microsoft\Excel\XLSTART

If you create a custom Toolbar per the code found at Debra's site, you will
still the macros that the customizations point to.

That's why I suggested Personal.xls to contain the macros and the workbook code
to create the Toolbar.


Gord


On Fri, 8 Dec 2006 11:16:02 -0800, TT wrote:

Thank you Gord for your reply as well. But I can't seem to find the
personal.xls or the Excelxx.XLB file anywhere in my computer. I tried doing
a search on all my directories, and they are nowhere to be found. Are they
hidden files or in hidden folders?? When the search is running, it does say
that the search is not looking in hidden folders or hidden files.

Another question is, if I succeed in creating a customized toolbar, as
outlined in your instructions, does that mean I don't have to email the
personal.xls file as well? Or do I have to do both steps?

"Gord Dibben" wrote:

Sending Personal.xls home will get your macros home but if you have made a
custom toolbar with buttons to run the macros, they will not be available on
your home computer.

Customizations to Menus and Toolbars are saved in your Excelxx.XLB file.

If only a customized Toolbar, you could attach it to Personal.xls.

Otherwise you could send the Excelxx.XLB file home also and overwrite your
current one on home computer.

This is not always desirable.

Best method of assigning macros to buttons is to build the Toolbar when you open
the workbook and delete it when you close.

Do not make the changes to the existing toolbars.

See Debra Dalgleish's website for Dave Peterson help on building "on the fly"
toolbars and menus.

http://www.contextures.on.ca/xlToolbar02.html


Gord Dibben MS Excel MVP



On Fri, 8 Dec 2006 07:51:00 -0800, TT wrote:

I see. Thank you very much. Now I understand. I'll try it and let you know
if it works.

"CLR" wrote:

Email the personal.xls file home. You can find it by doing Start Search
For files and folders in Windows Explorer........you may have to re-create
the buttons at home but you'll have the macros.

Vaya con Dios,
Chuck, CABGx3





"TT" wrote:

When I created the macros, I didn't save them in a particular file. Instead,
I saved them in my personal.xls, which can then be applied to all the files I
open using the application.

I know for sure these macros are not associated with the file because if I
open the file in someone else's computer, there's no macros buttons on their
excel application.

"CLR" wrote:

Macros that are recorded are stored in the same file that you recorded them
in. When you save that file, you save the macros therein. Just email that
file home and the macros will be there when you open it.

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

The problem is I have no idea where the macros are saved. The macros I
created are not custom macros (I'm only a beginner in macros, and I only know
how to create macros using the "record macro" function, and then assigning
them to a button), so I don't know where this type of macros are saved, or
how they are saved.

"CLR" wrote:

If the macros reside in an Excel file, just email it........

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

I have created a whole bunch of macros on my work computer. How do I copy
all these macros to my home computer??

Gord Dibben MS Excel MVP

Macros - copying macros from one computer to another
 

Maybe you are recording the macros in your workbook.

Go to ToolsMacroRecord new macro.

When the dialog box comes up for you to name the macro and other options, in the
"store macro in" is Personal Macro Workbook selected?

If not, your macros could be in whatever workbook you had open at the time.

If PMW was selected, you will have a Personal.xls somewhere on your system,
maybe not on your computer but in the citrix environment......I don't know how
these networks operate and where they store files.

Yes...Excel can run just fine without a Personal.xls


Gord Dibben MS Excel MVP

On Fri, 8 Dec 2006 12:35:01 -0800, TT wrote:

I did select & uncheck the options that you told me to do, I did manage to
find a XLB file, but I still can't find the Personal.xls file. What would I
be doing wrong?

If I have recorded any macros, I must have that file, correct? Would it be
possible that no such file exist in my computer? Can excel run without this
file? My excel is working fine.

Actually I'm running excel in a citrix environment, but I occasionally run
excel from my local machine, using excel application stored in my local
machine. I tried creating a macro in my local excel application, and
assigning it to a custom button, and then do the search for this Personal.xls
file, but I still can't find it. Please help.

"Gord Dibben" wrote:

TT

Open My Computer from Desktop and go to ToolsFolder OptionsView

Scroll down and check "show hidden folders and files"

Uncheck "hide extensions for known file types".

Now do your search................

Normal storage for *.xlb file is

C:\Documents and Settings\username\Application Data\Microsoft\Excel

For Personal.xls is

C:\Documents and Settings\Gord\Application Data\Microsoft\Excel\XLSTART

If you create a custom Toolbar per the code found at Debra's site, you will
still the macros that the customizations point to.

That's why I suggested Personal.xls to contain the macros and the workbook code
to create the Toolbar.


Gord


On Fri, 8 Dec 2006 11:16:02 -0800, TT wrote:

Thank you Gord for your reply as well. But I can't seem to find the
personal.xls or the Excelxx.XLB file anywhere in my computer. I tried doing
a search on all my directories, and they are nowhere to be found. Are they
hidden files or in hidden folders?? When the search is running, it does say
that the search is not looking in hidden folders or hidden files.

Another question is, if I succeed in creating a customized toolbar, as
outlined in your instructions, does that mean I don't have to email the
personal.xls file as well? Or do I have to do both steps?

"Gord Dibben" wrote:

Sending Personal.xls home will get your macros home but if you have made a
custom toolbar with buttons to run the macros, they will not be available on
your home computer.

Customizations to Menus and Toolbars are saved in your Excelxx.XLB file.

If only a customized Toolbar, you could attach it to Personal.xls.

Otherwise you could send the Excelxx.XLB file home also and overwrite your
current one on home computer.

This is not always desirable.

Best method of assigning macros to buttons is to build the Toolbar when you open
the workbook and delete it when you close.

Do not make the changes to the existing toolbars.

See Debra Dalgleish's website for Dave Peterson help on building "on the fly"
toolbars and menus.

http://www.contextures.on.ca/xlToolbar02.html


Gord Dibben MS Excel MVP



On Fri, 8 Dec 2006 07:51:00 -0800, TT wrote:

I see. Thank you very much. Now I understand. I'll try it and let you know
if it works.

"CLR" wrote:

Email the personal.xls file home. You can find it by doing Start Search
For files and folders in Windows Explorer........you may have to re-create
the buttons at home but you'll have the macros.

Vaya con Dios,
Chuck, CABGx3





"TT" wrote:

When I created the macros, I didn't save them in a particular file. Instead,
I saved them in my personal.xls, which can then be applied to all the files I
open using the application.

I know for sure these macros are not associated with the file because if I
open the file in someone else's computer, there's no macros buttons on their
excel application.

"CLR" wrote:

Macros that are recorded are stored in the same file that you recorded them
in. When you save that file, you save the macros therein. Just email that
file home and the macros will be there when you open it.

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

The problem is I have no idea where the macros are saved. The macros I
created are not custom macros (I'm only a beginner in macros, and I only know
how to create macros using the "record macro" function, and then assigning
them to a button), so I don't know where this type of macros are saved, or
how they are saved.

"CLR" wrote:

If the macros reside in an Excel file, just email it........

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

I have created a whole bunch of macros on my work computer. How do I copy
all these macros to my home computer??

Gord Dibben MS Excel MVP

Macros - copying macros from one computer to another
 

I see. ok, I will try again. thanks

"Gord Dibben" wrote:

Maybe you are recording the macros in your workbook.

Go to ToolsMacroRecord new macro.

When the dialog box comes up for you to name the macro and other options, in the
"store macro in" is Personal Macro Workbook selected?

If not, your macros could be in whatever workbook you had open at the time.

If PMW was selected, you will have a Personal.xls somewhere on your system,
maybe not on your computer but in the citrix environment......I don't know how
these networks operate and where they store files.

Yes...Excel can run just fine without a Personal.xls


Gord Dibben MS Excel MVP

On Fri, 8 Dec 2006 12:35:01 -0800, TT wrote:

I did select & uncheck the options that you told me to do, I did manage to
find a XLB file, but I still can't find the Personal.xls file. What would I
be doing wrong?

If I have recorded any macros, I must have that file, correct? Would it be
possible that no such file exist in my computer? Can excel run without this
file? My excel is working fine.

Actually I'm running excel in a citrix environment, but I occasionally run
excel from my local machine, using excel application stored in my local
machine. I tried creating a macro in my local excel application, and
assigning it to a custom button, and then do the search for this Personal.xls
file, but I still can't find it. Please help.

"Gord Dibben" wrote:

TT

Open My Computer from Desktop and go to ToolsFolder OptionsView

Scroll down and check "show hidden folders and files"

Uncheck "hide extensions for known file types".

Now do your search................

Normal storage for *.xlb file is

C:\Documents and Settings\username\Application Data\Microsoft\Excel

For Personal.xls is

C:\Documents and Settings\Gord\Application Data\Microsoft\Excel\XLSTART

If you create a custom Toolbar per the code found at Debra's site, you will
still the macros that the customizations point to.

That's why I suggested Personal.xls to contain the macros and the workbook code
to create the Toolbar.


Gord


On Fri, 8 Dec 2006 11:16:02 -0800, TT wrote:

Thank you Gord for your reply as well. But I can't seem to find the
personal.xls or the Excelxx.XLB file anywhere in my computer. I tried doing
a search on all my directories, and they are nowhere to be found. Are they
hidden files or in hidden folders?? When the search is running, it does say
that the search is not looking in hidden folders or hidden files.

Another question is, if I succeed in creating a customized toolbar, as
outlined in your instructions, does that mean I don't have to email the
personal.xls file as well? Or do I have to do both steps?

"Gord Dibben" wrote:

Sending Personal.xls home will get your macros home but if you have made a
custom toolbar with buttons to run the macros, they will not be available on
your home computer.

Customizations to Menus and Toolbars are saved in your Excelxx.XLB file.

If only a customized Toolbar, you could attach it to Personal.xls.

Otherwise you could send the Excelxx.XLB file home also and overwrite your
current one on home computer.

This is not always desirable.

Best method of assigning macros to buttons is to build the Toolbar when you open
the workbook and delete it when you close.

Do not make the changes to the existing toolbars.

See Debra Dalgleish's website for Dave Peterson help on building "on the fly"
toolbars and menus.

http://www.contextures.on.ca/xlToolbar02.html


Gord Dibben MS Excel MVP



On Fri, 8 Dec 2006 07:51:00 -0800, TT wrote:

I see. Thank you very much. Now I understand. I'll try it and let you know
if it works.

"CLR" wrote:

Email the personal.xls file home. You can find it by doing Start Search
For files and folders in Windows Explorer........you may have to re-create
the buttons at home but you'll have the macros.

Vaya con Dios,
Chuck, CABGx3





"TT" wrote:

When I created the macros, I didn't save them in a particular file. Instead,
I saved them in my personal.xls, which can then be applied to all the files I
open using the application.

I know for sure these macros are not associated with the file because if I
open the file in someone else's computer, there's no macros buttons on their
excel application.

"CLR" wrote:

Macros that are recorded are stored in the same file that you recorded them
in. When you save that file, you save the macros therein. Just email that
file home and the macros will be there when you open it.

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

The problem is I have no idea where the macros are saved. The macros I
created are not custom macros (I'm only a beginner in macros, and I only know
how to create macros using the "record macro" function, and then assigning
them to a button), so I don't know where this type of macros are saved, or
how they are saved.

"CLR" wrote:

If the macros reside in an Excel file, just email it........

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

I have created a whole bunch of macros on my work computer. How do I copy
all these macros to my home computer??

Gord Dibben MS Excel MVP

Macros - copying macros from one computer to another
 

I finally located the personal.xls file, and I copied it to my home computer.
It works. Thank you so much.!!

"CLR" wrote:

You're welcome.......I keep my personal.xls file on a pocket Jump Drive and
take it wherever I go..........

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

I see. Thank you very much. Now I understand. I'll try it and let you know
if it works.

"CLR" wrote:

Email the personal.xls file home. You can find it by doing Start Search
For files and folders in Windows Explorer........you may have to re-create
the buttons at home but you'll have the macros.

Vaya con Dios,
Chuck, CABGx3





"TT" wrote:

When I created the macros, I didn't save them in a particular file. Instead,
I saved them in my personal.xls, which can then be applied to all the files I
open using the application.

I know for sure these macros are not associated with the file because if I
open the file in someone else's computer, there's no macros buttons on their
excel application.

"CLR" wrote:

Macros that are recorded are stored in the same file that you recorded them
in. When you save that file, you save the macros therein. Just email that
file home and the macros will be there when you open it.

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

The problem is I have no idea where the macros are saved. The macros I
created are not custom macros (I'm only a beginner in macros, and I only know
how to create macros using the "record macro" function, and then assigning
them to a button), so I don't know where this type of macros are saved, or
how they are saved.

"CLR" wrote:

If the macros reside in an Excel file, just email it........

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

I have created a whole bunch of macros on my work computer. How do I copy
all these macros to my home computer??

Macros - copying macros from one computer to another
 

I finally located the file and copied it to my other computer. It works.
Thank you very much.

"CLR" wrote:

You're welcome.......I keep my personal.xls file on a pocket Jump Drive and
take it wherever I go..........

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

I see. Thank you very much. Now I understand. I'll try it and let you know
if it works.

"CLR" wrote:

Email the personal.xls file home. You can find it by doing Start Search
For files and folders in Windows Explorer........you may have to re-create
the buttons at home but you'll have the macros.

Vaya con Dios,
Chuck, CABGx3





"TT" wrote:

When I created the macros, I didn't save them in a particular file. Instead,
I saved them in my personal.xls, which can then be applied to all the files I
open using the application.

I know for sure these macros are not associated with the file because if I
open the file in someone else's computer, there's no macros buttons on their
excel application.

"CLR" wrote:

Macros that are recorded are stored in the same file that you recorded them
in. When you save that file, you save the macros therein. Just email that
file home and the macros will be there when you open it.

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

The problem is I have no idea where the macros are saved. The macros I
created are not custom macros (I'm only a beginner in macros, and I only know
how to create macros using the "record macro" function, and then assigning
them to a button), so I don't know where this type of macros are saved, or
how they are saved.

"CLR" wrote:

If the macros reside in an Excel file, just email it........

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

I have created a whole bunch of macros on my work computer. How do I copy
all these macros to my home computer??

Macros - copying macros from one computer to another
 

Thanks for the feedback.............I'm glad you got it working...........it
feels good to "be portable",huh?

Vaya con Dios,
Chuck, CABGx3


"TT" wrote in message
...
I finally located the file and copied it to my other computer. It works.
Thank you very much.

"CLR" wrote:

You're welcome.......I keep my personal.xls file on a pocket Jump Drive
and
take it wherever I go..........

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

I see. Thank you very much. Now I understand. I'll try it and let
you know
if it works.

"CLR" wrote:

Email the personal.xls file home. You can find it by doing Start
Search
For files and folders in Windows Explorer........you may have to
re-create
the buttons at home but you'll have the macros.

Vaya con Dios,
Chuck, CABGx3





"TT" wrote:

When I created the macros, I didn't save them in a particular
file. Instead,
I saved them in my personal.xls, which can then be applied to all
the files I
open using the application.

I know for sure these macros are not associated with the file
because if I
open the file in someone else's computer, there's no macros
buttons on their
excel application.

"CLR" wrote:

Macros that are recorded are stored in the same file that you
recorded them
in. When you save that file, you save the macros therein. Just
email that
file home and the macros will be there when you open it.

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

The problem is I have no idea where the macros are saved. The
macros I
created are not custom macros (I'm only a beginner in macros,
and I only know
how to create macros using the "record macro" function, and
then assigning
them to a button), so I don't know where this type of macros
are saved, or
how they are saved.

"CLR" wrote:

If the macros reside in an Excel file, just email it........

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

I have created a whole bunch of macros on my work
computer. How do I copy
all these macros to my home computer??

Macros - copying macros from one computer to another
 

oh, yes, that's for sure.

"CLR" wrote:

Thanks for the feedback.............I'm glad you got it working...........it
feels good to "be portable",huh?

Vaya con Dios,
Chuck, CABGx3


"TT" wrote in message
...
I finally located the file and copied it to my other computer. It works.
Thank you very much.

"CLR" wrote:

You're welcome.......I keep my personal.xls file on a pocket Jump Drive
and
take it wherever I go..........

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

I see. Thank you very much. Now I understand. I'll try it and let
you know
if it works.

"CLR" wrote:

Email the personal.xls file home. You can find it by doing Start
Search
For files and folders in Windows Explorer........you may have to
re-create
the buttons at home but you'll have the macros.

Vaya con Dios,
Chuck, CABGx3





"TT" wrote:

When I created the macros, I didn't save them in a particular
file. Instead,
I saved them in my personal.xls, which can then be applied to all
the files I
open using the application.

I know for sure these macros are not associated with the file
because if I
open the file in someone else's computer, there's no macros
buttons on their
excel application.

"CLR" wrote:

Macros that are recorded are stored in the same file that you
recorded them
in. When you save that file, you save the macros therein. Just
email that
file home and the macros will be there when you open it.

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

The problem is I have no idea where the macros are saved. The
macros I
created are not custom macros (I'm only a beginner in macros,
and I only know
how to create macros using the "record macro" function, and
then assigning
them to a button), so I don't know where this type of macros
are saved, or
how they are saved.

"CLR" wrote:

If the macros reside in an Excel file, just email it........

Vaya con Dios,
Chuck, CABGx3



"TT" wrote:

I have created a whole bunch of macros on my work
computer. How do I copy
all these macros to my home computer??