Mid and Left Statements Issues

[Ricky]

I use a excel VBA to open a comma delimited file. I then process it one line
at a time to break it into columns. I use the "MID" and the "LEFT" commands.
I have the MID command in a called subroutine.
The VBA works perfectly fine when I run it on my computer. When I try to run
it on other computers with the same EXCEL2007, the computers don't recognize
the MID or the LEFT command. First they say project or lib not defined. Then
they say PATH not found.
If I start a new VBA macro and put a MID function in it, it works just fine.
Is there something with the CALL subroutine that would mess up the Mid
function?
I've tried looking thru excel options for differences in setting, but alas
no luck.
Any help would be greatly appreciated.

 

[Bernie Deitrick]

Ricky,

There is nothing wrong with the code - the other computers have different
versions of the required reference files, so one or more of your references
in the project are broken. In the VBE, use Tools / References and look for
references labeled missing, and find appropriate replacements for those
files. You may be able to figure out what about your set up is different.

HTH,
Bernie
MS Excel MVP

 

[Ricky]

Ricky,

There is nothing wrong with the code - the other computers have different
versions of the required reference files, so one or more of your references
in the project are broken. In the VBE, use Tools / References and look for
references labeled missing, and find appropriate replacements for those
files. You may be able to figure out what about your set up is different.

HTH,
Bernie
MS Excel MVP




.

Hi Bernie,
Thanks for the information. It led me right to the problem.
I found that I hadan extra DLL checked at my computer, and when I went to
the other computer, it was "MISSING".
I was not really using it, but by unchecking the DLL, it went away, and the
VBA now works. The DLL was Xtreme Suite Controls Active X Control 11.2.1.

I had copies of the VBA on my computer and unchecked this and found that it
is not necessary even on my computer. I wasn't using any exotic ActiveX
Controls.

I think when I was building this VBA, I went looking for more exotic command
buttons, and may have linked this DLL at that time.
Thanks again, your help was immensely appreciated.
Ricky