Cannot create ActiveX component error when writing to excel

[Anonymous]

Inventor 2018, Excel 2016, Windows 7 enterprise

Here is the code I have been using

Here is the error message 

 

This code does work on other machines.

[bradeneuropeArthur]

Can you please upload your complete code, so we can test it?

Regards,

Autodesk Software: Inventor Professional 2018 | Vault Professional 2018 | Autocad Mechanical 2018
Programming Skills: Vba | Vb.net (Add ins Vault / Inventor, Applications) | I-logic
Dimension Component! | Partlist Export! | Derive I-properties! | Vault Prompts Via API! | Vault Handbook/Manual!
Drawing Toggle Sheets! | Vault Defer Update!

! For administrative reasons, please mark a "Solution as solved" when the issue is solved !

[chandra.shekar.g · Accepted solution]

@Anonymous,

Please go through below system requirements for Inventor 2018.

https://knowledge.autodesk.com/support/inventor-products/learn-explore/caas/sfdcarticles/sfdcarticles/System-requirements-for-Autodesk-Inventor-2018.html  

Basically, Inventor 2018 is 64 bit application. Just guessing that excel 2016 would be 32 bit application. This might be root cause for error.

Thanks and regards,

[Anonymous]

I cannot upload the rest of the rules but they all work. It is just the excel rule that is broken.

[bradeneuropeArthur]

If I remove the first line ....Open(....) then it works.

[Anonymous]

Unfortunately I am still getting the error without the first line.