Weird w2k Excel behaviour, will not shell properly

[petermeachem]

We have a few windows 2000 pc's which show this strange behaviour, the xp ones do what you would expect.
What I am doing is to create a spreadsheet from Access and then shelling to it. Xp shows you the spreadsheet but w2k shows the Excel menus, buttons etc but a completely blank area where the spreadsheet should be. If I select print preview, I can see the thing and print it out. Close preview and I get the blank area again. Double clicking on the file in Explorer displays it properly. Using Excel 2002.

Should it make any difference, the end of the code is

xlBook.SaveAs "c:\overdrive\Contract " & cContractNo & " Customer Statement.xls"
xlBook.Close ' False
xlApp.Quit
Set xlBook = Nothing
Set xlApp = Nothing

lret = ShellExecute(Forms!frmmainmenu.hwnd, "open", "c:\overdrive\Contract " & cContractNo & " Customer Statement.xls", vbNull, vbNull, SW_SHOWNORMAL)

 

[SkipVought]

Peter,

Please post VBA questions in Forum707.

It is not clear whether you are doing EVERYTHING is VBA or only some things that you describe above.

"...the end of the code is..."

... and the beginning and middle???




Skip,

_{Just traded in my old subtlety...
for a brand NUANCE!}