Posts by zzobe64

    trying to export an excel 2000 chart to a word doc using VB. I've tried everything. All the code I found on the web won't work. I keep getting a runtime error stating that the export did not work. Here is an example of the code


    Worksheets("Chart").Activate
    ActiveSheet.ChartObjects("Chart 1").Activate
    Pic = ActiveChart.Export("c:\BOFFEO.gif", FilterName:="GIF")