Microsoft Office Forums - View Single Post - Open excel files from sharepoint by using word wba

Peterson · 11-04-2021, 08:23 AM

To get the full path, i.e., C:\Users\username, use:

Code:

Environ("USERPROFILE")

This function does not include a backslash at the end, so your code will need to include it:

Code:

strWorkbook = Environ("userprofile") & "\" & "YOUR PATH HERE\Word List.xlsx" ' The workbook path