johnboy691 Posted October 28, 2008 Report Share Posted October 28, 2008 Hi All: I have a csv file located on the company server(s) which I access through the X: drive, which is a share drive. When something is saved to this share drive it is duplicated immediately on other servers using drives. ie: S, T, U, W, etc. Most processors access this shared drive through the X: drive. Some however, especially our home telecommuters access the exact same files but using the path of one of the other drives as noted above. My macro now uses the ASCII File Begin Process command using the path X:\FSA\Macro Express\User ID List.csv Is there a way I can Find what path is the share drive letter for those processors who use S, or T, or U, or W, etc.? If there is I could have the macro copy that info into a variable and have the macro go to the operational part of the macro and look for the file using that processor's share drive letter. Thanks for any help you can give. John Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.