Microsoft office automation error

-2

I am receiving an error when i try to create an excel workbook through a vb6 application. the error is a Microsoft Software Installer error 0x80004023. i have read over a similar question on a different site and tried the solution but it did not solve the problem. this is the other question here.

i am wondering if i need to delete ALL the matching CSLID keys with the same code as the excel application because there is more than one location where the key is for excel, or if i need to delete all the CSLID keys for all the applications. its just not explained well in the other question.

NickHallick

Posted 2014-06-27T14:16:57.427

Reputation: 39

1Which OS are you trying to use it on? Which version and edition of Office? Has it ever worked as expected with this configuration? – Ƭᴇcʜιᴇ007 – 2014-06-27T14:46:35.543

its on windows 7, office 2010 64 bit. it has worked on windows 7 office 2013, however the code allows for this action to work on any office version. – NickHallick – 2014-06-27T15:19:38.980

If this is the first time you've tried to use it with the 64-bit Office, then that's most likely your problem. MS recommends installing 32-bit Office even on 64-bit machines for similar reasons. Do you have the code to the VB6 program so you can debug it? – Ƭᴇcʜιᴇ007 – 2014-06-27T16:00:15.407

I have actually since repaired the office 2010 and apparently some of the registry keys were broken. it has fixed it and i can import information to excel. – NickHallick – 2014-06-27T16:02:39.153

Nice, you should post what you did as an answer for future visitors (you're allowed to answer your own questions) – Ƭᴇcʜιᴇ007 – 2014-06-27T16:03:31.240

Answers

1

What i did to fix this problem was to delete all the keys in the registry linked to excel applications (found in the link in the question). i then repaired office and restarted the computer which fixed the problem and allowed me to create a workbook through visual basic.

NickHallick

Posted 2014-06-27T14:16:57.427

Reputation: 39