PC Review


Reply
Thread Tools Rate Thread

Custom app user-defined chart type deployment

 
 
Jeff K
Guest
Posts: n/a
 
      29th Apr 2004
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?
 
Reply With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      30th Apr 2004
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?


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
User defined chart-type error Neil Microsoft Excel Discussion 1 13th Dec 2010 11:00 PM
Share excel user defined custom chart type in powerpoint. T-Casey Microsoft Powerpoint 4 1st Oct 2008 09:38 PM
Setting up a Custom type, User-defined, Default Chart =?Utf-8?B?S3VydA==?= Microsoft Excel Charting 0 22nd Dec 2005 07:43 PM
using vba to copy user-defined chart type =?Utf-8?B?UGFwYSBKb25haA==?= Microsoft Excel Programming 0 14th Oct 2005 04:14 PM
User-defined chart type deployment =?Utf-8?B?SmVmZiBL?= Microsoft Excel Programming 1 2nd May 2004 02:23 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:59 AM.