Forum Discussion
Solved
UserName in saved path of excel macro
Hi All. I have a macro that creates a PDF from the spreadsheet. I save this to a central onedrive folder. On my own PC, this is "C:\Users\Bill\OneDrive - Folder two\PDF's". I want all my users to be ...
Try
Environ("HomeDrive") & Environ("HomePath") & "\OneDrive - Folder two\PDF's"
(Do all users really have a folder named OneDrive - Folder two?)
Try
Environ("HomeDrive") & Environ("HomePath") & "\OneDrive - Folder two\PDF's"
(Do all users really have a folder named OneDrive - Folder two?)
Thanks again Hans, this worked.
The Folder name is not as I used in my example. It is a company shared folder.
The Folder name is not as I used in my example. It is a company shared folder.