I have a spreadsheet (that someone else wrote) which is giving this error, but only on some PC's.
It works fine on the PC it normally runs on (using Excel 2000), but gives the error above on all other PCs that I've tried at work (also with Excel 2000). However, trying it on a PC running Excel 2003, there's no error, so I'm pretty certain it isn't looking for objects in another file.
I've checked the references in VBA on the work PCs and they're all the same on both the PC it works on, and the ones that it doesn't work on.
So this has got me stumped! Any suggestions?
Bookmarks