View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
shoba[_3_] shoba[_3_] is offline
external usenet poster
 
Posts: 1
Default VBA code to check if a custom chart exists


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


--
shoba
------------------------------------------------------------------------
shoba's Profile: http://www.excelforum.com/member.php...o&userid=24676
View this thread: http://www.excelforum.com/showthread...hreadid=392889