I have searched about 20 or so pages of google and couldn't find a solution to this runtime.

Runtime error '-2147024770 (8007007e)'
Automation error
The specified module could not be found.

If anyone here could help me out I would be grateful.
and this isnt the -2147"00"24770 runtime error I tried its solution too.

As far as this thread is concern, caperjack has solved it...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.