Error 48: Error in loading dll

[hobbez]

Hey everyone
I searched the forum for possible answer to my question but came short...

I have an excel to txt parser which worked fine on win2000, but when I transfered it to windows XP we came upon this problem. When we try to parse excel file this error comes up, it does not mention particular dll, not sure if I am missing something in properties, preferences or something third...
since obviously I am not too farmiliar with VB or possible causes of this I sincerely hope someone might help...

prog starts, then comes to line where it is supposed to open excel file:

/code
Set wSource = Workbooks.Open(Trim(Start.Text1.Item(0)), False, True)
/code

and there it breaks and reports error in topic.
it was written in visual basic 6.0

 

[gmmastros]

Does that machine that is causing problems have Excel installed on it?

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[hobbez]

Yes it does! Both machines have MS excel 97 installed

 

[HughLerwill]

Hobbez,

I am a little suprised you are getting an error 48 on the line in question.

This error 'normally' happens if you disribute a vb6 app without including one of its dependant files in the installation. It can be difficult to identify which one; I gave an possible solution to that in thread222-1050587.

Are you sure the error is a 48 and it is happening on the line given.

What happens when you use Start.Text1.Item(0), could it involve a .dll?

HTH Hugh,