TrippyTom
04-08-2008, 08:20 AM
I've been creating macros for my department to make our lives easier, and it's become so popular I need to consolidate all the different versions (for the locations around the world) and put it into one file to keep my sanity. So I think I need to create some folder checking on a specific network drive to make sure my toolbar shows up with the custom icons for every user.
As it happens, each branch saves them in a different path, but they're always going to be on Z:\, for instance. So am I right in thinking I need an IF EXIST routine? I've never used one before, so would appreciate some guidance.
Here are the paths for the icons the toolbar uses:
1) Z:\Tripp\Productivity Macros\images\
2) Z:\Shape Gallery\Macros\images\
3) Z:\_Templates\Macros\images\
As it happens, each branch saves them in a different path, but they're always going to be on Z:\, for instance. So am I right in thinking I need an IF EXIST routine? I've never used one before, so would appreciate some guidance.
Here are the paths for the icons the toolbar uses:
1) Z:\Tripp\Productivity Macros\images\
2) Z:\Shape Gallery\Macros\images\
3) Z:\_Templates\Macros\images\