Excel crashes using Terminal Server

[Robert Sheppard]

I am stumped by this problem.
I have a remote machine that uses terminal server to run some internal apps
at our main office. Some of those apps use the Excel 9.0 object lib to
create some excel reports. This works great internally and with some of our
clients using terminal server.

But, some of our clients get a crash when trying to create these Excel
reports.

error 1004: unable to set the centerhorizontally property of the PageSetup
class.

Set oWorkbook = oApp.Workbooks.Add()
Set oWorksheet = oWorkbook.Worksheets(1)

oWorksheet.PageSetup.CenterHorizontally = True
oWorksheet.PageSetup.Zoom = False
oWorksheet.PageSetup.FitToPagesWide = 1
oWorksheet.PageSetup.FitToPagesTall = 1000
oWorksheet.PageSetup.Orientation = xlLandscape

I have tried everything. It doesnt work. It works here and from other remote
locations but not others.

The remote location that is not working is running XP.

Any ideas?