VBA: Create a new folder on any users desktop and save the file as value in cell (A51)

Sorry to hijack the thread but I have been looking every where for a solution and you guys seem to have the answers. VBA FTW, I am trying to use your code below. It works as written to create the folder on the desktop but, I need it to save the workbook with a file name listed in cell ("A51"). Any way you can help?

HTML Code: 

What I want is for my remote employees to click a command button which will check for the folder on the deskop. If it is not there create it and save the file.

Thanks in advance,

Hi,

The code is already very close, just needed a few extra lines beneath the FolderExists label.

I hope this helps

Works Great! Do you know how to surpress the runtime error if you are to press no or cancel when the "file already exists do you want to overwrite.
Run Time Error.jpg

Sure, change the If...Then...Else loop below the FolderExists label to the following:

Please Login or Register  to view this content.

The Application.DisplayAlerts = False tells Excel to just overwrite the file without asking you if that's what you want to do or not.

Hope this helps

I would rather it not overwrite automatically, i want the overwrite warning just to close if user presses no or cancel and say msgBox "File Not Saved"

Ah OK sorry, try this file then

I have created a custom overwrite prompt so as to avoid the error.

That seems to be the ticket! You sir are a gentleman and a scholar. I have been messing with the code for 2 days.

Hahaha no problem, glad I could help

Please don't forget to mark this thread as solved and please click on the * next to my post to say thanks