Hello! I have two issues I could use help with (assuming it's even possible). First off, here's my current code:
This code works beautifully, but there are two sections I'd like to be less fixed if possible.
The first portion is:
This currently saves the doc as "Goal_8.01.16.xlsm" to "C:\test\08_August_2016\" which works great, except it requires me to go in each month and update the destination folder. So in September, I'll have to go into the code and change 08_August_2016 to 09_September_2016. Not anything major, takes literally less than a minute to do, but if I can figure out how to make that section of code update based on the C2 cell (which just has the date a goal is being made for), that'd mean it never has to be updated.
I'm thinking something where I maybe set up a few more strings that pulls the month from C2 and turns it in to a number in mm format and then text? Everything I"ve tried so far has failed, so any ideas would be splendid.
Second, I have this script set to save images to MY desktop, but is there a way to have it save to the user's desktop? If I use it then cool, but if I want someone else to use this it won't save the images I want because it's hardcoded to say C:\mrbusto. If there's some code that'd change it to be the username of the person saving the file that'd be amazing.
Thanks for reading, sorry for the long post!
Bookmarks