Problems with Excel automation and Office 2007.

vpta

We have a terminalservere farm with three servers in cluster. On Monday we did an upgrade to MSOffice 2007 (from 2003). After upgrade we are not able to use Excel automation and Excel buffer. I have tried to change automation server / automation variable, recompiling objects, re-reg comdlg32.ocx and re-installed Navision client. No luck :-(

I have the same behaviour on different verisions of the database.

If I open the client from a PC it is working ok.

My Navision client is 5.0SP1. / Server 5.0 / SQL 2005

I think this might be an MSoffice error - anyone?

ta5

Do you get any error?
Regards
Thomas

vpta

Yes (see attachment)... The error msg depends on function (.ADD .OPEN .SAVE )

ta5

Does the variable in the variable window look ok (e.g. Microsoft Excel...)?

vpta

Yes - and if I am running the code on a PC that has NOT been upgraded - everything is ok.