Set acApp = CreateObject("Access.Application") Window 7 - XL2010

[cwunderlich]

Hello,

I am trying to work with a VBA macro which loads data from a microsoft excel file onto an Access database. This previously worked under our old systems (which also had Excel 97-03 and a previous version of Windows). This last week we were upgraded to Microsoft Office 2010 and Windows 7.

The code below is the section I found in our current modules which I believe does the loading onto the Access database (I did not create the original code).

However, now, when the macro hits the first line of code shown below I get a Run-Time error '429' error message that says "ActiveX component can't create object"


[/code]
Set acApp = CreateObject("Access.Application")
acApp.Visible = True
acApp.OpenCurrentDatabase ("...filepath\Experience.mdb") 'path to Access database
pathlocation = "..." 'file path of excel file
name = "..." 'what to name the table in the access database
[/code]


I am familiar with VBA, but this sort of syntax is out of my current realm / area of knowledge, so I hope this info is enough to go off of. Any help would be greatly appreciated

Thank you.

 

[cwunderlich]

anyone?

 

[cwunderlich]

bump