Consulting

Results 1 to 4 of 4

Thread: Finding the Folder that the working file is in

  1. 04-11-2007, 01:24 PM #1
    Maurice
    Maurice is offline
    VBAX Regular
    Joined
    Mar 2007
    Posts
    16

    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.
    Reply With Quote Reply With Quote
  2. 04-11-2007, 02:03 PM #2
    Bob Phillips
    Bob Phillips is offline
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Activeworkbook.Path
    Reply With Quote Reply With Quote
  3. 04-12-2007, 07:41 AM #3
    Maurice
    Maurice is offline
    VBAX Regular
    Joined
    Mar 2007
    Posts
    16
    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
    Reply With Quote Reply With Quote
  4. 04-12-2007, 08:38 AM #4
    lucas
    lucas is offline
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules