Thank you very much for the advice, Tom. Will now write macros using lower
version of Excel.


"Tom Ogilvy" wrote:

In the VBE go to tools=References and in the references at the top, there
should be at least one shown as MISSING. Although this is probably not
related to the MID function, that is just where Excel decides to tell you
about it. In any event, if you need this reference, then you need to fix
it by finding it on that machine using the browse button. If you don't need
it, then you should go back to your machine and the source file and remove
it there. Then save the file and redistribute.

As others have advised, you should do your development on the oldest version
of Excel that will need to use the code.

--
Regards,
Tom Ogilvy

"Francis Ang" wrote in message
...
I developed the following macros using Excel 2002 running on Windows XP
Professional -

If dir("C:\File_Name.txt")< "" then
my_data = mid(input,1,4)
Endif

When I execute the macro using Excel 1997 SR2 running on Windows 98 an
error
message pops up - 'Can't find project or library'

This greek to me. Can someone tell me I have done wrong and how to rectify
this situation.

Thank you.