Office Spreadsheet on VBA

Office Spreadsheet on VBA

Anonymous
Not applicable
1,592 Views
2 Replies
Message 1 of 3

Office Spreadsheet on VBA

Anonymous
Not applicable

Hi guys!

 

 

I have a problem that I just can't solve!

I have a VBA application that I used to run on AutoCAD 2013 and had no problemas at all, but when I tried to run it on AutoCAD 2017 all my spreadsheets vanish!

 

When I check my project's Reference, I see that "Microsoft Office Web Components" is not on the list, so I browse and load "owc11.dll".

 

But even so, when I look at "Additional Controls" at the Toolbox, "Microsoft Office Spreadsheet" is not there!

 

Can anyone help me? I already tried so many things and nothing solves this! Without the spreadsheets my project is useless!

 

 

Thanks!

0 Likes
Accepted solutions (1)
1,593 Views
2 Replies
Replies (2)
Message 2 of 3

norman.yuan
Mentor
Mentor
Accepted solution

You did not say what version of Windows and what version of MS Office you (and your users) are using. Here are somethigns you need to know:

 

1. Miscrosoft Office Web Components (OWC11.dll) was discontinued since MS Office 2007. So, theoretically, the computer running with your AutoCAD VBA app (up to Acad2013) must have MS Office 2003 (ouch!) installed, or somehow get OWC11.dll installed when later version of MS Office is installed.

 

2. Regardless which version of MS Office/Windows you use, since your Acad VBA code worked with AutoCAD 2013, the computer must have OWC11.dll installed. So, you have been lucky enough having been able to run your VBA code, using that old MS Office Web Components, ONLY BECAUSE the AutoCAD you had been using (up to Acad2013) uses 32-BIT VBA. Since Acad2014, if the AutoCAD is 64-bit, its VBA is also 64-bit. So, I'll bet your AutoCAD 2017 is 64-bit (no one runs 32-bit AutoCAD these days), thus the VBA is AutoCAD is also 64-bit. Therefore your luck of hanging on the good old OWC11.dll runs out: OWC11.dll is a 32-bit components, thus, cannot be used in 64-bit process (AutoCAD). Period.

 

So, you either intall 32-bit AutoCAD, or drop the VBA app (or rewite it without using OWC11.dll).

Norman Yuan

Drive CAD With Code

EESignature

Message 3 of 3

Anonymous
Not applicable

I didn't know that OWC11.dll is a 32-bit component.

 

Well, thanks a lot for your reply!

 

At least now I know what's wrong.

 


Thanks!

0 Likes