Maarten,

Check whether the other computer has missing links. In VBE, got to
ToolsReferences, and if any say Missing, uncheck them.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Bijl167 " wrote in message
...
Hi,

I have a problem which I hope someone can explain to me. An excel file
with a lot of macro's in it uses no "clean" declaration of variables (
so not Dim i As Integer i=1, but just i=1), so every parameter is
declared as Variable. On my computer this file works with out a
problem, on other computers the file gives an error message "cannot
find Library".

I know this has someting to do with option explicit, but my question is
how can I let the file work on the other computers without declaring all
the variables for the macro's (which will take me a couple of days)

Thanks in advance

maarten


---
Message posted from http://www.ExcelForum.com/