Excel VBA forms on Intranet

[Kay]

I have developed a form within Excel 2000 using VBA forms
which looks up names and parts of names within 1 of 3
worksheets - depending on the option chosen.

This works perfectly well when accessed via someones
desktop. However, once a link is placed to the file on the
intranet I get errors such as the one below

Method 'Worksheets' of object '_Global' failed

Can any one shed light on this and how to get around it as
all that I try creates another error and I end up trying
to fix that and losing focus on the real problem.

Any help very much appreciated

Thank you

 

[Bill Li]

Do you use the file name in the code? If yes, you'd better
change them to URL address.

Best Regards

Bill

 

[Rob Kay]

Thanks for that - it wasn't quite what you said but it did put me on the
right track - it now works

Thanks again


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!