Hi,

I have an Excel application which attempts to convert charts to gif images,
using the code (ChartPath is equal to a valid directory location):

ActiveChart.Export Filename:=ChartPath, FilterName:="GIF"

This works perfectly on one PC, but fails when I try to run it on a
different PC. Both PC's use Windows 2000, and both run Excel 2000.

What I need to find out is what could possibly be causing this statement to
fail. Is there something in the Excel or Windows settings that could be
different (a dll file etc)?

Hope that someone might be able to help,

Regards,

Rob Bath

What's the text of the error message ?

Tim

"Robbath" wrote in message
...
Hi,

I have an Excel application which attempts to convert charts to gif
images,
using the code (ChartPath is equal to a valid directory location):

ActiveChart.Export Filename:=ChartPath, FilterName:="GIF"

This works perfectly on one PC, but fails when I try to run it on a
different PC. Both PC's use Windows 2000, and both run Excel 2000.

What I need to find out is what could possibly be causing this
statement to
fail. Is there something in the Excel or Windows settings that could
be
different (a dll file etc)?

Hope that someone might be able to help,

Regards,

Rob Bath

.... and check for the required filters under:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Graphics
Filters\Export


Tim

"Robbath" wrote in message
...
Hi,

I have an Excel application which attempts to convert charts to gif
images,
using the code (ChartPath is equal to a valid directory location):

ActiveChart.Export Filename:=ChartPath, FilterName:="GIF"

This works perfectly on one PC, but fails when I try to run it on a
different PC. Both PC's use Windows 2000, and both run Excel 2000.

What I need to find out is what could possibly be causing this
statement to
fail. Is there something in the Excel or Windows settings that could
be
different (a dll file etc)?

Hope that someone might be able to help,

Regards,

Rob Bath

Tim,

thanks for replying,

the error message I received was:

Run-time error '1004':
Method 'Export' of object ' _Chart' failed

Regards,

Rob

"Tim Williams" wrote:

What's the text of the error message ?

Tim

"Robbath" wrote in message
...
Hi,

I have an Excel application which attempts to convert charts to gif
images,
using the code (ChartPath is equal to a valid directory location):

ActiveChart.Export Filename:=ChartPath, FilterName:="GIF"

This works perfectly on one PC, but fails when I try to run it on a
different PC. Both PC's use Windows 2000, and both run Excel 2000.

What I need to find out is what could possibly be causing this
statement to
fail. Is there something in the Excel or Windows settings that could
be
different (a dll file etc)?

Hope that someone might be able to help,

Regards,

Rob Bath