I have a workbook, which saves pdf's to a folder created when first open workbook on the laptop. Problem is, how do I change or make generic the folder location so that this workbook and macro's will work on a dozen different laptops? Here is the code I am using.
This is the code to setup the folder
This is one of the macro's which save the workbook as a pdf in that folder above. The "David" is Savefolder is what needs to change for each user or somehow be "universal" to work on all laptops. I tried **, but it looks for a folder with that in it.
Thanks for any help provided!
Bookmarks