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

directory stack

After enabling Windows Server 2012 R2 DHCP Failover Getting Packet dropped because of Client ID hash mismatch

WMI Repository 4GB limit - Win 2003 Ent Question