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/groups?selm=3F...01%40yahoo.com
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Jeff K wrote:
> 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?