We'd need to see the specific errors you are encountering.

But probably, the other PC's have either different versions of Excel or
different operating systems (Win2000 vs WinXP for example), resulting in
different paths to the library or analysis references.

On the PC it is not working on, go to VBA, Tools, References and look for
anything that says "MISSING". I have had problems with "funcres", "atpvbaen"
and "solver". These are fine on one PC but missing on another.

I don't believe there is any solution for this. If there is I'd like to hear
it. It is as if VBA hardwires the path to the references rather than
dynamically finding them.

-- Rev


wrote in message
ups.com...

VBA Runs fine on my PC but errors on other PC's

How on earth do i find out WHY this is happening? as you can imagine,
its frustrating as my code runs fine on my machine, so obviously i
cannot find the errors...

any ideas, help etc gratefully received (apart from using the other
machines to develop on as not really convenient...)