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")