Consulting

Results 1 to 4 of 4

Thread: Finding the Folder that the working file is in

  1. #1

    Finding the Folder that the working file is in

    HELP !
    I would like to get the workbook containing the vba code to find out the folder that it is in and the path to it so that I don't have to store multiple paths for different users. I would be very grateful for a clue as I have been on a cicular tour so far. The FileSearch method is not available to me because the version of office is a non-commercial one.
    Thank you in anticipation.

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master xld's Avatar
    Joined
    Apr 2005
    Posts
    25,142
    Location
    Activeworkbook.Path

  3. #3
    Can an answer possibly be that short? I'm flabbergasted. Thank you very much indeed, I will try it Pronto and I will now search for the smilie for Solved

  4. #4
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    For solved...use the thread tools at the top of the page.
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

Posting Permissions

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