Hide Progress bar in Chart.Export

  • Thread starter Thread starter vikrambade
  • Start date Start date
V

vikrambade

Hi,

I have a Excel Workbook which has 2 Worksheets. One work sheet has dat
and the 2nd worksheet has a graph based on the data. I have a Macr
which connects to the datasource, updates the data in the 1st workshee
and further saves the graph on worksheet in to a GIF image in the fil
system. I do that using:

Sheet2.ChartObjects(1).Chart.Export Filename:="c:\AutoChart.gif"
FilterName:="GIF"

But this opens a small progress bar which shows the progress bar fo
generating the GIF image.

Now, i want to automate this process of calling the Macro from a VB Ap
and schedule it using Autosys/SQLAgent/Windows Scheduler so tha
without opening any GUI, the graphs should be generated on a dail
basis.

Now, How to Hide the Progress Bar????

HELP!!!!

Vikra
 
Have you tested it with Autosys/SQLAgent/Windows Scheduler? Does it
really not work?

Consider turning off display alerts with Application.DisplayAlerts.
This property turns off certain alerts, though not all. Dunno if the
one of interest to you is covered by it.


--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top