Hi all,

i have to export Diagrams out of Excel 2003 during an automatic analysis,
and i have some trouble with it. If i use the standard way (in my
understanding) with VBA like this:

    Dim Dia As Chart
    Set Dia = Worksheets("Tabelle1").ChartObjects(1).Chart
    Dia.Export Filename:="Test.gif", FilterName:="GIF"
    Set Dia = Nothing

i get always a "runtime error 1004: method 'export' for object '_Chart'
failed" (this is translated from german to english, so maybe the sentence
is not real the same as in your version of excel).    

I tried some different formattings for the code above, with complete paths
in a line or with the paths in variables, some other export-filters like
JPG and so on, but always without success.

At the moment i'm using a workaround as exporting the table with the
embedded diagram as a web-page, and there _IS_ a bitmap (GIF) inside, which
i can use then. But because the amount of data sometimes is huge and the
analysis will generate sometimes more than 30 tables, this workaround is
consuming much ressources withoud need.

Thanks for any hint,

regards, Jens