Custom app user-defined chart type deployment

[Jeff K]

I have an application that uses custom chart types. I'm
now running Excel 2002 under XP Professional. These
chart types in prior version of Excel were stored in the
XLgalry.xls, and more recently XLUSrgal.xls. I can't
find these files on my machine.
1) What is the file and the path where these user-defined
custom chart types are located? Are they hidden?
2) Could I deploy this appplication by copying that file
to the target machine's directory? (albeit risking an
overwrite). I want to avoid going over to each
propective user's machine and updating chart types by
opening Excel.
3) What is the most elegant, programmatic way of using
the specialized chart types without overwriting custom
chart types already defined on the target machine?

 

[Jon Peltier]

Jeff -

The files aren't hidden as in invisible, but they are hidden in that the
directory structure gets more labyrinthine with each release of Office.
You could copy the files, but as you fear, you might hose someone's
carefully crafted custom charts. You would deserve the beating.

Here's a technique for deploying custom chart types to numerous machines:

http://www.google.com/[email protected]

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