Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    milton keynes, Buckinghamshire
    Posts
    252
    Thanks
    0
    Thanked 0 Times in 0 Posts

    file path (2000)

    I need to find the full file path of the current file that I am working on.

    I have tried

    x = ThisWorkbook.Path
    y = Application.Path
    Range("A1").Value = x
    Range("A2").Value = Application.Path

    But A1 comes up blank and A2 comes up with the path to the excel application.

    Can someone please let me have the correct syntax

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: file path (2000)

    ActiveWorkbook.FullName gives the complete path and filename of the current workbook. Of course, if the workbook hasn't been saved yet, there is only a name, no path.

  3. #3
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    milton keynes, Buckinghamshire
    Posts
    252
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: file path (2000)

    Thanks

    That has worked

Posting Permissions

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