"The Accounting Dept informed me that the file they are updating is not being updated."
So which is the host and which is the receiving machine here? Where is the programme resident? XP machine or 7 machine?
Are you sure that you mean a mapped drive?
A mapped drive is just a shared folder on one machine, that appears over the network as a drive on another. It can be done manually, for the ordinary home user, or scripted, in a corporate setting.
So, for example, my " family" folder is shared and can be seen by my children on their PCs.
I will make this a "mapped drive" when I get round to it by visiting their machines and giving it a drive letter (probably F: ). There is a command in Win 7 for this in the Tools menu. You simply choose a drive letter from the list and then navigate the network to the folder you want. Or you can do it the old fashioned way in a DOS command line with SUBST
Or at work we have a bunch of different user groups, each has its own set of permissions and access rights. Each will find their files stored in a set of lettered drives, which they can have access to according to their group membership, with the admin group being able to see all of these folders. Each group's core folders have a drive letter, e.g. drive S: for shared resources. In fact these are all mapped drives on the server and sit as folders in the same physical machine.
But, the mapped folder/drive doesn't need to synchronise. It is shared in realtime and stays resident on the host machine.
So maybe you mean something else. Or maybe the spreadsheet is saving to a different folder. Or the receiving machine is looking at a different folder. Your script hasn't changed in five years, but your PCs have. Are the new machines actually included in the group? Was the script specifiically set up for you, those five years ago, for that configuration?
Or see this article http://www.amset.info/loginscripts/network-drives.asp