After further investigation, I have found that the problem exists when
we open the file using a shortcut, icon, or xla shortcut.
When I open the file by opening excel first and then open the file by
using the path file/open etc., the code works fine.
It seems for some reason that it can't figure out what the correct path
is without opening excel that way first.
The 2 guys with the problem can open the file that way, but I would
still like for them to use their shortcut or xla shortcut.
Any ideas?