Home > Community > Automation and VBA > Automating JPEG export of charts > Antwort auf: Automating JPEG export of charts

Michael HaagMichael Haag

Dear Sir or Madam,

I have tried to automate the JPEG export of embedded charts. The document containig the charts is about 30 pages long and the number of charts is about 40.

In the HTML help I have found the following method:

Ausdruck.Export(Format, PathName, Interactive, PageNumber)

The arrays which contain the sheetnumber, the index of the chart and the Pathname are already definded.

So, my question is how do I have to write the method so that it is possible to export all charts by means of a for loop?

Specifically how is the appearance of the part “Ausdruck”? The part “Ausdruck” should contain expressions so that I can export each chart with the aid of a for loop.

Is that possible?

Yours sincerely