Consulting

Results 1 to 2 of 2

Thread: Solved: IF EXIST routine?

  1. #1
    VBAX Expert TrippyTom's Avatar
    Joined
    Jul 2005
    Location
    New York, NY (USA)
    Posts
    556
    Location

    Solved: IF EXIST routine?

    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\
    Office 2010, Windows 7
    goal: to learn the most efficient way

  2. #2
    VBAX Expert TrippyTom's Avatar
    Joined
    Jul 2005
    Location
    New York, NY (USA)
    Posts
    556
    Location
    Um... nevermind. It was simpler than I thought.

    This link answered all my questions:
    http://www.tek-tips.com/faqs.cfm?fid=4116
    Office 2010, Windows 7
    goal: to learn the most efficient way

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •