record an excel macro, save on network so that everyone can access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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....
 
Conajo

Save the workbook with the macro as an Add-in(*.xla) and stick that somewhere
all users can access and load in Tools>Add-ins.


Gord Dibben Excel MVP
 
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
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.
 
Make sure you chose "Microsoft Excel Add-In (*.xla)" in the Save as Type box on
the File|SaveAs dialog.
 
And just give a name.

Excel will look after adding the .xla extension


Gord
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro Will Not Save 2
Tracking Access in Read-Only Files 0
Excel 2007: Help creating a macro that will run Solver? 3
Macros Available without hiding 'personal.xls'? 3
Personal.xls will not open when I open excel 2
Auto adding a macro when Excel 2003 opens 3
Vista problem with NO Personal Macro Workbook in Startup Folder 6
excel xp macros cannot be saved to personal.xls 3

Back
Top