VBA code to check if a custom chart exists

S

shoba

Hi,

I'm using custom chart types to re-generate multiple charts in a
workbook automatically. The final workbook will be used on other PC's.
So before I let the generation start, I'd like to check
programmatically if a custom chart exists on the particular PC.

Anyone got a suggestion how do this? I know the custom chart types are
stored as charts in a separate file xlusrgal.xls, but I don't want to
open that workbook to check if the chart exists. Is there no generic
object in VBA to check if a custom chart exists?

Thanks in advance.
Bart
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard 2
Paste Excel Chart into Existing Powerpoint Chart 1
Excel 2010. How to copy chart format to all charts in sheet 2
For each chart loop not working 2
Stack overflow exception, when chart is selected 1
Checking if a Chart Exists on a Sheet 6
Axes(xlCategory) for a chart-sheet in 2007 2
Is there a way in VBA to check if a particular Sub exits inThisWorkbook? 1

Top