Home |
Search |
Today's Posts |
#1
|
|||
|
|||
record an excel macro, save on network so that everyone can access
How do I record a macro in Excel, and have it available for everyone to use
from a network location? Saving it in "Personal.xls" does not make it available to any other computer user. Saving it under any other choice makes it always refer back to another file after save as.... |
#2
|
|||
|
|||
Conajo
Save the workbook with the macro as an Add-in(*.xla) and stick that somewhere all users can access and load in ToolsAdd-ins. Gord Dibben Excel MVP On Tue, 8 Feb 2005 11:55:07 -0800, Conajo wrote: How do I record a macro in Excel, and have it available for everyone to use from a network location? Saving it in "Personal.xls" does not make it available to any other computer user. Saving it under any other choice makes it always refer back to another file after save as.... |
#3
|
|||
|
|||
Thanks
Will give it a try and see how it works...I am trying to make life more easy for some of the more computer illiterate at where I work, and I probably know just enough to be dangerous...:-) "Gord Dibben" wrote: Conajo Save the workbook with the macro as an Add-in(*.xla) and stick that somewhere all users can access and load in ToolsAdd-ins. Gord Dibben Excel MVP On Tue, 8 Feb 2005 11:55:07 -0800, Conajo wrote: How do I record a macro in Excel, and have it available for everyone to use from a network location? Saving it in "Personal.xls" does not make it available to any other computer user. Saving it under any other choice makes it always refer back to another file after save as.... |
#4
|
|||
|
|||
Gord
I saved the file with .xla, placed it on a drive on our server. Opened Excel, Tools, add ins, browsed for the file, tried to open it, and it tells me this file is not a valid add in. "Gord Dibben" wrote: Conajo Save the workbook with the macro as an Add-in(*.xla) and stick that somewhere all users can access and load in ToolsAdd-ins. Gord Dibben Excel MVP On Tue, 8 Feb 2005 11:55:07 -0800, Conajo wrote: How do I record a macro in Excel, and have it available for everyone to use from a network location? Saving it in "Personal.xls" does not make it available to any other computer user. Saving it under any other choice makes it always refer back to another file after save as.... |
#5
|
|||
|
|||
Make sure you chose "Microsoft Excel Add-In (*.xla)" in the Save as Type box on
the File|SaveAs dialog. Conajo wrote: Gord I saved the file with .xla, placed it on a drive on our server. Opened Excel, Tools, add ins, browsed for the file, tried to open it, and it tells me this file is not a valid add in. "Gord Dibben" wrote: Conajo Save the workbook with the macro as an Add-in(*.xla) and stick that somewhere all users can access and load in ToolsAdd-ins. Gord Dibben Excel MVP On Tue, 8 Feb 2005 11:55:07 -0800, Conajo wrote: How do I record a macro in Excel, and have it available for everyone to use from a network location? Saving it in "Personal.xls" does not make it available to any other computer user. Saving it under any other choice makes it always refer back to another file after save as.... -- Dave Peterson |
#6
|
|||
|
|||
And just give a name.
Excel will look after adding the .xla extension Gord On Thu, 10 Feb 2005 16:34:30 -0600, Dave Peterson wrote: Make sure you chose "Microsoft Excel Add-In (*.xla)" in the Save as Type box on the File|SaveAs dialog. Conajo wrote: Gord I saved the file with .xla, placed it on a drive on our server. Opened Excel, Tools, add ins, browsed for the file, tried to open it, and it tells me this file is not a valid add in. "Gord Dibben" wrote: Conajo Save the workbook with the macro as an Add-in(*.xla) and stick that somewhere all users can access and load in ToolsAdd-ins. Gord Dibben Excel MVP On Tue, 8 Feb 2005 11:55:07 -0800, Conajo wrote: How do I record a macro in Excel, and have it available for everyone to use from a network location? Saving it in "Personal.xls" does not make it available to any other computer user. Saving it under any other choice makes it always refer back to another file after save as.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Open Access Database under and Excel window using a Macro | Excel Worksheet Functions | |||
Export Excel Data to Access With a Macro!!! | Excel Discussion (Misc queries) | |||
Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) | |||
How do I save a record from an excel template to a database in a . | Excel Discussion (Misc queries) |