library that contains "Mid" function

[celestinogalan]

I have done an excel macro (VB) an into it I have this line:

"Sheets("datos&quot.Cells(x2, 1).Value = Mid(LineaLeida, 1, 8)"

When I run the macro in other computer than mine, it appears a box saying something like "I cant found the library or the proyect.... EVEN if I install the VBruntime6.0sp5.......... in that computer.
¿What can I do? ¿is there an other library?

Maybe another way is to make an VB application instead an excel macro.... in that case does anybody know how to open an excel sheet from VB and interact with it?

Thanks

 

[Nikita6003]

This is caused by a missing reference: go to TOOLS > REFERENCES in the VBA Editor on the machine where you get the error, and look in the list for anything preceded by the word MISSING. If this reference isn't needed to run your macro just uncheck, if it IS: make sure that the component is installed on the PC.

Funny thing is that xl stumbles over functions such as MID (it awked at RIGHT in my case ;-)) which are pretty standard and usually have nothing to do with the MISSING reference.

Hope this helps

Cheers
Nikki

 

[celestinogalan]

thanks. It seems to work but i THINK I cannot tell users of my excel macro "please go to TOOLS > REFERENCES in the VBA Editor on the machine where ......" because they don't know anything.... dou you know?

do you understand me?

What can I do?

 

[Nikita6003]

What's the reference that's missing? Does your code actually NEED this?
If not, uncheck the reference in your xl sheet & distribute TAH version - should work ;-)

Cheers
Nikki

 

[celestinogalan]

It works, thanks