Exporting Macros In Excel
 

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

Exporting Macros In Excel
 

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
--
Gary''s Student - gsnu200753


"funbdave" wrote:

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

Exporting Macros In Excel
 

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)

"funbdave" wrote in message
...
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