Printing a chart from VBA

[Iain]

Hi all,

Wonder if anyone here can point me in the right direction:

the following line of VBA:

CurrentChart.Chart.PrintPreview

where CurrentChart has been set as a chart object, works fine on my Excel XP
at home, however on Excel 2000 (tried on both my office PC and an office
laptop), this line causes run-time error 2147417848 (80010108) Method
'PrintPreview' of object 'CurrentChart' failed- subsequently, Excel will not
close and the PC requires a restart to get going again.

I can Print Preview the chart manually without problem on all machines.

All machines are up to date on service packs/patches and despite a lengthy
search of the microsoft knowledgebase I've been unable to find anything that
touches on this. Article 319832 seemed relevant (early binding) but after
following guidance here, problem still exists.

Any one know of other potential causes of this?

TIA

Ellis.

 

[Tom Ogilvy]

No reason it shouldn't work on Excel 2000.