Office Automation on 64bit Windows 2008
Does 64bit 2008 server support automation of excelwhen using dcom/vb6 application? I followed the instruction (http://support.microsoft.com/kb/288367)to configure excel to run as a specific user. It works perfectly in 32bit versionsof2003 and 2008 servers, but not in 64 bit 2008 server. On the 64 bit environment, if i register the com application as interactive user, then excel opensperfectlydepending on who is logged in at the time. If I register the com app as Library, then I would expect excel to launch as the OfficeAutomationUser. In task manager I see the excel processlaunchedwith my userid instead. The error message i get is: Method '~' of object '~' failed The application fails when i try to open the workbook.VB6 code: Code Snippet Set xlApp = New Excel.ApplicationSet xlBook = xlApp.Workbooks.Open("c:\temp\DetProdRptTmpl.xls") xlBook.SaveAs strFileName xlBook.Close xlSaveChanges Set xlBook = Nothing xlApp.Quit I tried allthree 32bit versions ofOffice (2000, 2003 and 2007) with no luck at all. Any help would be greatly appreciated
May 14th, 2008 12:26pm

This looks more like an Office issue than a Windows Server 2008 issue, even though you are trying to get it to run on Windows Server 2008. http://forums.microsoft.com/TechNet/ShowForum.aspx?ForumID=2007&SiteID=17is the Office 2007 forum. You may want to put this post over there, as you are likely to find people more knowledgeable about Office and its inner workings over there. tgc
Free Windows Admin Tool Kit Click here and download it now
May 15th, 2008 12:44am

Thanks Tim
May 15th, 2008 11:17am

Hi FCainI've got the same problem here .... did you find a solution ?Thanks in advanceSTef
Free Windows Admin Tool Kit Click here and download it now
July 7th, 2008 11:40pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics