2 Replies - 4262 Views - Last Post: 10 June 2013 - 08:13 PM Rate Topic: -----

#1 jruss2630  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 3
  • Joined: 15-May 07

VB6 cannot create excel object with excel 2013

Posted 06 June 2013 - 01:03 AM

Has anyone tried reading/writing to excel in Office 2013? Up to Office 2010 I have had no problem. Now when I try to create the excel object, I get the error '429 Active X cannot create the object'. I have seen some Microsoft KB's that say that the solution is to include MSADDNDR.DLL in your distribution package as it no longer ships with Office 2013.
I have tried all this and still have the same problem.

The error occurs with the CreateObject statement,

Dim ExcelApp As Excel.Application
Set ExcelApp = CreateObject("excel.application")


Surprisingly I don't see any comments about this on the forums.
Any help would be much appreciated.

Is This A Good Question/Topic? 0
  • +

Replies To: VB6 cannot create excel object with excel 2013

#2 tlhIn`toq  Icon User is offline

  • Please show what you have already tried when asking a question.
  • member icon

Reputation: 5442
  • View blog
  • Posts: 11,676
  • Joined: 02-June 10

Re: VB6 cannot create excel object with excel 2013

Posted 06 June 2013 - 07:28 AM

So latest version of Excel with VB6 which has been dead for a decade... I'm no VB expert but I have to say it doesn't surprise me to see two products separated by a decade not working well together. Have you considered moving your project into the current programming era and build it in VB.NET?



Please read: This is not the VB.NET forum
Please read: Is learning VB6 now a complete waste of time?
Was This Post Helpful? 1
  • +
  • -

#3 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 574
  • View blog
  • Posts: 2,989
  • Joined: 19-May 09

Re: VB6 cannot create excel object with excel 2013

Posted 10 June 2013 - 08:13 PM

Do you have a reference to the Excel Object library in your application? If you don't, you'll get the error you mention.
Was This Post Helpful? 1
  • +
  • -

Page 1 of 1