Compiler wont recognize the mid or string$ functions?

[Jooky68]

I am trying to compile my code on a new machine and for some reason the compiler will not recognize the mid or string$ function. When looking through the object browser it says these functions are contained in the string class within VBA, whose DLL file is vba6.dll. I have a reference to vba6.dll in my references but it still wont recognize the string functions. Does anyone have any clue??? Please help.

 

[jel]

Can't help you there, but just a tip: it might very well be that the real problem is not what VB says it is.
I had the same error (string functions were not recognized) while the actual problem proved to be: a double declaration on an enumerator or a constant, after adding a reference to a project that used the same enum/const.

 

[merlinx]

A long time ago.....

I had the same problem, (ms98/off97/v-studio6 sp3), it turned out that it was due to an installation failure due to a comcat dll defect from office. I had to reinstall everything with a new office cd.....

Have you tried these functions in the Office vba editor?

 

[tudogs]

I had a similar problem not long ago.

The problem turned out to be my own stupidity.

I was trying to work with files on one computer that had origonaly been written on another computer (same type of computer and OS). After trying for almost 3 days I finally discovered that the new computer did not have SP5 installed.
Upon installation of SP5 every thing worked.

Hope this is not your problem

good luck

Bob