Solved

What's the best way to share an Excel Macro

Posted on 2009-04-04
1
310 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
Comment Utility
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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

772 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now