Solved

What's the best way to share an Excel Macro

Posted on 2009-04-04
1
313 Views
Last Modified: 2012-05-06
SO I wrote a Macro on my system in VBA - what is the best method for sharing this Macro? It will need to be installed on a handful of computers at work running Excel 2003.
0
Comment
Question by:ThePATMAN26
1 Comment
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 500 total points
ID: 24069245
Hello ThePATMAN26,

There are several ways; I would lean toward creating an add-in myself.  The following articles should be enough
to explain the basic concepts for add-ins; you can come back with more specific questions for your particular
needs.

http://www.ozgrid.com/VBA/excel-add-in-create.htm
http://msdn.microsoft.com/en-us/library/aa140936(office.10).aspx

Regards,

Patrick
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Determine dependencies 3 22
Excel formula that pulls back the id 4 42
Compare data between two sheets in Excel 6 33
Excel format formula with percentage 3 9
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question