Using OWC11.dll Spreadsheet Control in 64 bit Office VBA?

Question

I have some legacy VBA projects (in Excel mostly) that make use of the OWC11.dll Spreadsheet Control in various userforms.  The spreadsheet control is a convenient way to get user input and provide feedback on various engineering processes that we've automated.  This code was originally done with Office 2003, then upgraded to Office 2007 with no problem, as long as we installed OWC11 (Office Web Components) on the users' machines first.

We are now looking at upgrading to Window 7 64 bit and Office 2010 64 bit.  We are having trouble getting OWC11 to work in Office 2010 64 bit.  We can install OWC11 on the machine.  We can add a reference to the OWC11.dll library in an Office 2010 VBA project.  But I cannot find any way to add the Spreadsheet Control to the VBA toolbox in Office 2010 64 bit.  If I open an existing VBA project, the spreadsheet control is missing on any of the user forms, rendering them unusable.

My hunch is that the problem is that OWC11.dll is a 32 bit ActiveX library and Office 2010 64 bit won't run a 32 bit ActiveX library - but I haven't been able to confrim this for sure.  Has anyone had a similar experience and found a solutions?

 

p.s.  I know the proper thing to do would be to start my project over and do all this with Visual Studio Tools for Office - and I would do that if I was starting from scratch.  But this is legacy code that I just want to get working again with minimal fuss.

Answer 1

hi,

 

it is necessary that DLL is present in system32 and syswow64 folder and register it with the full path to each file

i hope this helps

 

--

isabelle

 Le 2011-09-20 10:10, Ben Slater a écrit :

> I have some legacy VBA projects (in Excel mostly) that make use of the OWC11.dll Spreadsheet Control in various userforms. The spreadsheet control is a convenient way to get user input and provide feedback on various engineering processes that we've automated. This code was originally done with Office 2003, then upgraded to Office 2007 with no problem, as long as we installed OWC11 (Office Web Components) on the users' machines first.

>

> We are now looking at upgrading to Window 7 64 bit and Office 2010 64 bit. We are having trouble getting OWC11 to work in Office 2010 64 bit. We can install OWC11 on the machine. We can add a reference to the OWC11.dll library in an Office 2010 VBA project. But I cannot find any way to add the Spreadsheet Control to the VBA toolbox in Office 2010 64 bit. If I open an existing VBA project, the spreadsheet control is missing on any of the user forms, rendering them unusable.

>

> My hunch is that the problem is that OWC11.dll is a 32 bit ActiveX library and Office 2010 64 bit won't run a 32 bit ActiveX library - but I haven't been able to confrim this for sure. Has anyone had a similar experience and found a solutions?

>

> p.s. I know the proper thing to do would be to start my project over and do all this with Visual Studio Tools for Office - and I would do that if I was starting from scratch. But this is legacy code that I just want to get working again with minimal fuss.

>

 

Answer 2

I have had a similar problem posted for at least a year.  I have windows 7 64 bit  office 2010  32 bit (as i develop for 32 bit users)

it makes use of OWC11 - a great active X - But when i transfer this to machines eg Windows XP office 2007  where they have already have OWC installed and try to redirect it to this one .  Or install it again to the place I have it installed and reregister it they have problems.  We seem to have it in slightly different directories

It doesnt work .  Cant add spreadsheet objects etc - its like it doesnt recognize it

This appears to have been a problem for at least two years but no one seems to be able to solve it  - Look back at some of my old posts

Any thoughts greatly appreciated 

Ps do i need to uninstall the original OWC11's - Reinstalling seems to be a problem.  do i need to clear out registry values - and if so what ones. is there an unistaller for owc11?

---

Gazman

Answer 3

Did anyone come up with a solution?  The only way I could get OWC11 to work is by running the application in 32 bit mode.  I believe 64 bit applications can't run OWC11 (32 bit).

Answer 4

I still got the same problem running OWC11 on Office 2013 64 bit mode. Are there any new insights on this?