ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Chart.Export (https://www.excelbanter.com/charts-charting-excel/263511-chart-export.html)

Eric Boomsma

Chart.Export
 
I have a PC with Office 2007 and a PC with Office 2003. Ik am using a macro
wich uses the method Activechart.Export ("C:\TEMP\TEST.BMP") to export a
graph to a BMP file.
In Office 2007 everything works fine. In Office 2003 I am getting the error:
Error 1004. Method Export of object _Chart didn´t succeed.

I read something about importfilters. But I didn´t see the solution. Can
someone tell what I can do about it?


Jon Peltier[_2_]

Chart.Export
 
Try

Activechart.Export "C:\TEMP\TEST.PNG"

A PNG image file is a compressed bitmap.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
774-275-0064
http://peltiertech.com/


On 5/11/2010 4:00 AM, Eric Boomsma wrote:
Activechart.Export ("C:\TEMP\TEST.BMP")


Eric Boomsma

Chart.Export
 
Hello Jon,

This works. Thank you.

I can live with it.

Eric

"Jon Peltier" wrote:

Try

Activechart.Export "C:\TEMP\TEST.PNG"

A PNG image file is a compressed bitmap.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
774-275-0064
http://peltiertech.com/


On 5/11/2010 4:00 AM, Eric Boomsma wrote:
Activechart.Export ("C:\TEMP\TEST.BMP")

.



All times are GMT +1. The time now is 08:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com