PC Review


Reply
Thread Tools Rate Thread

disabling chart export progress bar

 
 
extrnh
Guest
Posts: n/a
 
      9th Jan 2008
i have a macro that exports charts as gif files using the following
code:

Charts(i).Export Filename:=strWebPath & "images\" &
strChartName & ".gif", FilterName:="gif"

when each chart is exported, a progress bar is displayed. i would
like to disable the display of the progress bar form, but
Application.DisplayAlerts = False and Application.ScreenUpdating =
False do not work.

any ideas on how to disable the display of the progress bar?


 
Reply With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      9th Jan 2008
I believe this is impossible.

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


"extrnh" <(E-Mail Removed)> wrote in message
news:1bf9cced-6816-460d-b7ad-(E-Mail Removed)...
>i have a macro that exports charts as gif files using the following
> code:
>
> Charts(i).Export Filename:=strWebPath & "images\" &
> strChartName & ".gif", FilterName:="gif"
>
> when each chart is exported, a progress bar is displayed. i would
> like to disable the display of the progress bar form, but
> Application.DisplayAlerts = False and Application.ScreenUpdating =
> False do not work.
>
> any ideas on how to disable the display of the progress bar?
>
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Export to Excel with form Progress Bar Daniel Microsoft Access 2 2nd May 2010 11:51 AM
chart export progress bar extrnh Microsoft Excel Misc 0 31st Aug 2007 07:20 PM
Hide graphics export progress bar Milos Microsoft Excel Programming 2 8th Mar 2005 05:58 AM
Hide Progress bar in Chart.Export vikrambade Microsoft Excel Charting 2 10th Apr 2004 05:04 AM
Export chart as image without the progress dialog mb Microsoft Excel Programming 1 12th Mar 2004 04:16 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:08 AM.