Office Automation on 64bit Windows 2008
does 64bit 2008 server support automation of excel when using dcom/vb6 application?
i followed instruction (http://support.microsoft.com/kb/288367) to configure excel run specific user. works in 32bit versions of 2003 , 2008 servers, not in 64 bit 2008 server.
on 64 bit environment, if register com application interactive user, excel opens perfectly depending on logged in @ time.
if register com app library, expect excel launch officeautomationuser. in task manager see excel process launched with userid instead.
the error message is:
method '~' of object '~' failed
the application fails when try open workbook. vb6 code:
set xlbook = xlapp.workbooks.open("c:\temp\detprodrpttmpl.xls")
xlbook.saveas strfilename
xlbook.close xlsavechanges
set xlbook = nothing
xlapp.quit
i tried all three 32bit versions of office (2000, 2003 , 2007) no luck @ all.
any appreciated
this looks more office issue windows server 2008 issue, though trying run on windows server 2008.
http://forums.microsoft.com/technet/showforum.aspx?forumid=2007&siteid=17 is office 2007 forum. may want put post on there, find people more knowledgeable office , inner workings on there.
tgc
Windows Server > Windows Server General Forum
Comments
Post a Comment