[Andrew]

My company currently uses excel 2000.
We are looking at upgrading to 2007 but need to determine if we can get our
estimating programs to work in the new version.

Currently in version 2000 we have some buttons on the toolbar that are
linked to macros:
i.e.: 'c:\folder\file.xls'!macro_name

The macro is not in the currently open file but in an external file.

I cannot seem to figure out how to make a button or shortcut to a macro in a
file like that.

Any ideas or something I am missing?

Thank you!
Andrew

[FSt1]

hi
in order for a macro to be availible, it must be in an open file.
macros that are file specific are usually kept in the specific file.
macros that are needed by an single user for multiple file use, usually
stores the macros in a personal file, hidden and place in the excel start
folder so that the personal.xls will open when excel starts and all of its
macro will be available.
puttng the macros in an addin is also an option.(i have never done that)
see this site about addins.
http://www.excelguru.ca/node/45

Regards
FSt1


"Andrew" wrote:

My company currently uses excel 2000.
We are looking at upgrading to 2007 but need to determine if we can get our
estimating programs to work in the new version.

Currently in version 2000 we have some buttons on the toolbar that are
linked to macros:
i.e.: 'c:\folder\file.xls'!macro_name

The macro is not in the currently open file but in an external file.

I cannot seem to figure out how to make a button or shortcut to a macro in a
file like that.

Any ideas or something I am missing?

Thank you!
Andrew

[Andrew]

I put the macro into the QAT bar and then manual edited the excel.qat file
with the file path of the macro. Now when I hit the button, it will open the
file and run the macro.



"FSt1" wrote:

hi
in order for a macro to be availible, it must be in an open file.
macros that are file specific are usually kept in the specific file.
macros that are needed by an single user for multiple file use, usually
stores the macros in a personal file, hidden and place in the excel start
folder so that the personal.xls will open when excel starts and all of its
macro will be available.
puttng the macros in an addin is also an option.(i have never done that)
see this site about addins.
http://www.excelguru.ca/node/45

Regards
FSt1


"Andrew" wrote:

My company currently uses excel 2000.
We are looking at upgrading to 2007 but need to determine if we can get our
estimating programs to work in the new version.

Currently in version 2000 we have some buttons on the toolbar that are
linked to macros:
i.e.: 'c:\folder\file.xls'!macro_name

The macro is not in the currently open file but in an external file.

I cannot seem to figure out how to make a button or shortcut to a macro in a
file like that.

Any ideas or something I am missing?

Thank you!
Andrew

[FSt1]

hi
sounds like you are using 2007. i haven't got that far yet. so disregard all
that i said.

regards
FSt1

"Andrew" wrote:

I put the macro into the QAT bar and then manual edited the excel.qat file
with the file path of the macro. Now when I hit the button, it will open the
file and run the macro.



"FSt1" wrote:

hi
in order for a macro to be availible, it must be in an open file.
macros that are file specific are usually kept in the specific file.
macros that are needed by an single user for multiple file use, usually
stores the macros in a personal file, hidden and place in the excel start
folder so that the personal.xls will open when excel starts and all of its
macro will be available.
puttng the macros in an addin is also an option.(i have never done that)
see this site about addins.
http://www.excelguru.ca/node/45

Regards
FSt1


"Andrew" wrote:

My company currently uses excel 2000.
We are looking at upgrading to 2007 but need to determine if we can get our
estimating programs to work in the new version.

Currently in version 2000 we have some buttons on the toolbar that are
linked to macros:
i.e.: 'c:\folder\file.xls'!macro_name

The macro is not in the currently open file but in an external file.

I cannot seem to figure out how to make a button or shortcut to a macro in a
file like that.

Any ideas or something I am missing?

Thank you!
Andrew