ok when i personally run the macro its fine

when my colleages run it it gives the error MsgBox

i asked my colleagus to go into the drive to see if they have access and the file opens fine for them!!!

but on the macro it doesnt ??????????????
aaaaahhhhhhhhhhhh!!!!!