[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 140
  • Last Modified:

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
0
bsharath
Asked:
bsharath
  • 3
  • 2
1 Solution
 
KCTSCommented:
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now