Can anyone create many macros in a file and have all the macros while opening any file

Hi,

Can anyone create a file with some macros and upload it on some server and tell me how i can get all the macros when ever i open a new file.Always have the macros.

regards
Sharath
LVL 11
bsharathAsked:
Who is Participating?
 
Brian PierceConnect With a Mentor PhotographerCommented:
You can create a microsoft office file (word/wxcel etc) and name a Macro "auto_open", this will run whenever the file is opened (subject to macro security settings).
0
 
[ fanpages ]IT Services ConsultantCommented:
Hi,

Assuming the server is within your organisation's domain, please refer to this page regarding the use of a "personal.xls" file:

"Deploy your Excel macros from a central file"
[ http://office.microsoft.com/en-us/excel/HA010872961033.aspx ]

BFN,

fp.
0
 
bsharathAuthor Commented:
KCTS
After creating the file where should i place this file.
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
bsharathAuthor Commented:
Can anyone help me with a macro file and upload it and tell me the location to put the file with a example please.
0
 
[ fanpages ]IT Services ConsultantCommented:
Did you read the link I provided?

The "personal.xls" file cannot be remote (i.e. outside of your network domain).

However... you could import a code module from a pre-defined (remote) location (text file) every time the workbook code is run (or the workbook is opened).

Please read my comments in these previous questions, and come back to me if you are unsure about any of the content:

"Calling VBA Code externally (via the internet)"
[ http://www.experts-exchange.com/Applications/MS_Office/Excel/Q_21424559.html ]

"Updating a Module Automatically"
[ http://www.experts-exchange.com/Applications/MS_Office/Excel/Q_21609845.html ]

"Patch/add modules in Excel application"
[ http://www.experts-exchange.com/Programming/Q_21608902.html ]

"Sharing Excel Macros thru Network share drive"
[ http://www.experts-exchange.com/Applications/MS_Office/Excel/Q_21613073.html ]

"Making a Particular Cell in Every Row a Button With VBA"
(with respect to creating local subroutines in a worksheet code module at run-time)
[ http://www.experts-exchange.com/Applications/MS_Office/Excel/Q_21612553.html ]


The above stategy may be a little advanced for what you are trying to achieve, though.

BFN,

fp.

0
 
[ fanpages ]IT Services ConsultantCommented:
Thanks for your feedback,
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.