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.