Export chart as image without the progress dialog

M

mb

Hi,

Is it possible to export a chart without the progress dialog?
I used
ActiveChart.Export Filename:="c:\test.gif", FilterName:="GIF",
Interactive:=False

The boxes become annoying when using Excel to generate WEB graphics!

Thanks,
Marc
 
D

Dave Peterson

What version of excel are you using?

I used xl2002 and did a file|saveas and chose .html.

It saved all the charts I had as .gif's in the folder under my .html file.

(I put a chart on a worksheet, selected it and ran your code. I didn't get any
dialogs.)

Sorry I couldn't test more in my version.
 

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

disabling chart export progress bar 1
export chart method error - excel2003 4
Export Pie Graph Chart as Image 7
runtime error 91 2
Export Chart as TIFF or JPG 8
[Excel 2003] Exporting Diagram as Bitmap with VBA 2
Programatically Export Excel Chart to Graphic in SharePoint 5
Exporting chart to GIF file 5

Top