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

Top