Vba code to open file from a specific path that works for every user except temp

Question

Workbooks.Open Filename:="C:\Desktop\VBA\Phase 1\A.xlsx"

How do I open the file from desktop or documents of any user.

Under desktop, There are subfolders with fixed names in which file is being kept so how to bypass those subfolders?? — yashika vaish, Jan 31 '18 at 04:44
Yes under desktop folders and subfolders names are the same. — yashika vaish, Jan 31 '18 at 05:37

score 3 · Accepted Answer · answered Jan 31 '18 at 05:42

Multiple ways you can do that, pick the one that works for you-

Option Explicit
Public Sub Example()
    Dim FilePath As String
    FilePath = CreateObject("WScript.Shell") _
                  .specialfolders("Desktop") & "\VBA\Phase 1\A.xlsx"
    Debug.Print FilePath
End Sub

Option Explicit
Public Sub Example2()
    Dim FilePath As String
    FilePath = Environ("USERPROFILE") & "\Desktop\VBA\Phase 1\A.xlsx"
    Debug.Print FilePath
End Sub

Vba code to open file from a specific path that works for every user except temp

1 Answers1