Exporting Macros In Excel

[Guest]

My clients us my software application to receive weekly data. In this
software application, they can export to Excel and create great presentations.

If I create an Excel Macro to turn rows and columns of data into exquisite
charts and graphs... how do I send this Macro to others so that they can
apply it to their data?

THANKS!


dls

 

[Guest]

I would just send them the speadsheet containing the macros:

1. They would get the macros
2. They could get samples of the execution of the macros
3. They would get a working environment to debug potential problems

 

[Chip Pearson]

The best way to do this is to create an Add-In
(http://www.cpearson.com/Excel/CreateAddIn.aspx) and distribute that to the
users. Keep the code separate from the data.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)