sharing a custom chart type

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Papa Jonah - 12 Oct 2005 13:35 GMT

I have a custom chart template that I use. I want to share it with a
coworker. How do I "export" it or copy it to their machine?

TIA

Reply to this Message

Ed Ferrero - 13 Oct 2005 06:57 GMT

Hi Papa,

Search for XLUSRGAL.XLS
In my PC (running Win XP) it sits in
C:\Documents and Settings\Ed\Application Data\Microsoft\Excel
(where Ed is the user name)

You will need to copy this to similar locations on each user's PC>

Ed Ferrero
http://edferrero.m6.net/

>I have a custom chart template that I use. I want to share it with a
> coworker. How do I "export" it or copy it to their machine?
>
> TIA

Reply to this Message

Jon Peltier - 15 Oct 2005 14:17 GMT

Let's hope the user doesn't already have custom types, because this will
overwrite them. A while ago I posted a solution that allowed you to
distribute custom chart types in a workbook with code to add these types
to a user's gallery:

http://groups.google.com/group/microsoft.public.excel.charting/msg/210f8a219326de1a

If you run this procedure from the Workbook_Open procedure, it will
update the user gallery when the file is opened.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

> Hi Papa,
>
[quoted text clipped - 12 lines]
>>
>>TIA

Reply to this Message