Format of Chart when export to .gif 1

[bdbBear]

I have the following line of code that takes a chart in Excel and converts it to a .gif file:

ActiveChart.Export strTempFilePath, "GIF"

I use Excel 2003 in WinXP. I've tested it in Excel 2K, Win2K and it worked fine. However, one of the users who runs the code in 2K had a bit of a problem.

When the .gif file is created it takes the formatting and messes it up a bit. The chart uses an Arial font but for him it isn't Arial but something not very clear.

Any idea of what is actually used to run the conversion process ... is it a funtion in a .dll or something?

Thanks!

- Bruce

 

[BobStubbs]

If this just happens to one user, could it be that the standard Arial font is missing / damaged on his workstation?

To check this, try getting the user to do the job on another workstation, while another user tries the workstation with the problem. If the fault 'stays put' on one workstation, then a font problem is likely.

I once had a similar problem, where Windows replaced the Arial font (via font aliasing) with Symbol. The result was Greek letters in the user's text! We found that Arial had been accidentally deleted.

Bob Stubbs (London, UK)

 

[bdbBear]

Thanks Bob.

Just sent over a new file with the chart having different fonts on it. Hopefully some will work and that it is just a font issue.

- Bruce