I have created a macro to combine multiple files which works on my PC using
excel 2000. However, when others run the macro, they get the follwoing error
:

Comipile error in hidden module : Module 3

It makes no difference on the version of excel they are using , be it 2000
or XP. On further investigation, runnimg the procedure from the VB editor
the error highlights the "left" of the first left function used and gives the
error :

Compile error : can't find project or library

From the fact that the errors occurs on a variery of versions of excel
including 2000, I have concluded that the remedy lies in the installation of
the excel package ot the add ins installed. I have compared mine and another,
(who gets the error) but can find very little different.

Does any one have any ideas where to look to reslove the problem?