xlusrgal.xls in excel 2007
 

Can anyone tell me how Excel 2007 handles the user-defined chart format? In
previous versions, user can create their own chart formats and copy/register
these foramts in Excel through xlusrgal.xls file. I am having problem in
converting my old macro to Excel 2007 because this file is no longer
supported by new Excel. Thanks.

Eric

xlusrgal.xls in excel 2007
 

Interesting question although I've never used xlusrgal.xls. I don't see
anything on this in the Knowledge base. I think an MVP should asked the
internal MS resources they have access to.<g

--
Jim
"Eric" wrote in message
...
| Can anyone tell me how Excel 2007 handles the user-defined chart format?
In
| previous versions, user can create their own chart formats and
copy/register
| these foramts in Excel through xlusrgal.xls file. I am having problem in
| converting my old macro to Excel 2007 because this file is no longer
| supported by new Excel. Thanks.
|
| Eric

xlusrgal.xls in excel 2007
 

I've been trying to figure out the rest of Excel 2007's charting
infrastructure, and I haven't even gotten to custom chart types. A short
excursion into this has been very interesting.

On the Chart Tools/Design tab, click on Save As Template, and the active
chart is saved as a chart template (for example, Chart1.crtx) in
C:\Documents and Settings\{user account}\Application
Data\Microsoft\Templates\Charts. The crtx file seems to contain just the
chart-related parts of an xlsx Excel 2007 workbook file.

Instead of juggling a bunch of chart sheets within a single gallery
workbook, now you can juggle a bunch of chart template files within this
directory (or presumably any hard disk location).

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


"Eric" wrote in message
...
Can anyone tell me how Excel 2007 handles the user-defined chart format?
In
previous versions, user can create their own chart formats and
copy/register
these foramts in Excel through xlusrgal.xls file. I am having problem in
converting my old macro to Excel 2007 because this file is no longer
supported by new Excel. Thanks.

Eric