Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 895
  • Last Modified:

VBA Automation Error - Run Time Error -2147024770 - Specified module could not be found

I found the same error in my search here, but the link to the download for a fix on MSDN was broke.

The error appears when I call a function in my module:

Set xmlRequestdoc = newJBXMLRequest(sessionID)

This program has been running fine for year and I have not changed any code in the program.  I checked my VBA references on this machine vs a working machine and the same list appears.

I beleive the machine I'm having the error on has had the 2007 add-in to allow to open 2007 files for quite a while now and I have not had this problem, the only thing I can think of is a recent 2007 file I was working with my Office 2003 install of Excel may have messed things up somehow.

Please let me know your thougts on how to fix this.
0
JMO9966
Asked:
JMO9966
  • 4
  • 2
2 Solutions
 
JMO9966Author Commented:
I've isolated further where the error occurs:

Function newJBXMLRequest(sessionID As String) As DOMDocument40

Dim result As New DOMDocument40
Set Session = result.createAttribute("Session")       'This is where the error happens

I have a reference in my VBA project to Microsoft XML, v4.0 that has always worked fine.  I'm not getting the error on both of my machines, obviously an update I did has changed something that VBA is referencing but I'm lost at how to fix this.
0
 
JMO9966Author Commented:
I re-wrote the application in vb.net and I get the same error.  It must be an issue with the COM object I'm referencing.
0
 
Robberbaron (robr)Commented:
is one machine 64bit, the other 32 bit ?  

 I have this issue with Autocad VBA routines; the DLL reference is there but doesnt work until I open the code on the correct target machine and resave. All ok after that.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
JMO9966Author Commented:
both machines are 32 bit.  thanks

Something strange with my machine I agree, just not sure how to fix it.

thanks
0
 
Robberbaron (robr)Commented:
if you edit and resave the app on the machine that is currently NOT working, does it then work ok on the other. This may help isolate the version of DLL causing issue.
0
 
JMO9966Author Commented:
I had to uninstall and re-install an older version version of the program that owns this com file.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now