well the first thing I would check is which workbooks/queries are not
working correctly and making sure that the new LAN path to access them has
not changed you may have to implement a "file exists" check for error
handling.. the other thing (and I myself haven't done this but from other
questions/networking point of view) there might be proxy server settings or
a firewall that is effecting your code.. again a check for file exist or
if connected might yield the answers .. other than that you may have to talk
to the sys admin to see if the change to LAN is the problem.