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:

code snippet
    set xlapp = new excel.application
    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

Popular posts from this blog

some help on Event 540

WMI Repository 4GB limit - Win 2003 Ent Question

Event ID 1302 (error 1307) DFS replication service encountered an error while writing to the debug log file