Save file to Desktop

**scrabtree23** · 06-09-2016, 01:03 PM

I have this code

Please Login or Register  to view this content.

This works great, but it saves the .PDF to the location of the master file. How can I get it to save to my Desktop, for example?

**Arkadi** · 06-09-2016, 01:14 PM

If it is only used by you, you can specify the path, if it is to work with any users desktop then it will have to be slightly more complex. For YOUR desktop:
replace ActiveWorkbook.Path with "c:\users\yourusername\desktop" where you replace the word yourusername with your actual username

**Arkadi** · 06-09-2016, 01:18 PM

Actually... a better way would probably be to dim a variable as string... call it myDesk or something... and then :

Please Login or Register  to view this content.

**Subverter** · 06-09-2016, 01:19 PM

Please Login or Register  to view this content.

**jolivanes** · 06-09-2016, 01:20 PM

I think that this is what Arkadi means for any and all computers.
Change the name "Test Report.pdf" to your filename.

Please Login or Register  to view this content.

**Arkadi** · 06-09-2016, 01:24 PM

yeah jolivanes, I had forgotten about the scripting shell option and was thinking about environment variables, but just after my first post remembered the easy route