I am trying to create a macro and have been doing some research. Unfortunately every time I go running it gives me issues. I have done two days' worth of research and I am still having problems. Any help is greatly appreciated!
I need a macro that:
Creates a folder in a specific location. That folder name needs to be base off of a cell in the excell document.
Then save each sheet as a separate PDF inside the above-said folder with the name of the sheet and the above-named info that the folder was created.
If all goes well I would like a message to pop up and say done, if something doesn't work or the folder already exists to pop up an error message.