Hello all,

I have a workbook that has an automatic save vba code that saves my file into a folder on my desktop. Currently I have to make that folder manually. This is fine if it is only on my computer but it is becoming a hassle when I put this workbook on other peoples computers then I have to make that folder on their computer and then change the directory path in the vba code.

What I would like to do is have it look for that folder on their desktop and if it is their then continue to save the file as normal. But, if it is not then create that folder and then continue to save file as normal.

Can anyone provide me some examples of how I can do this please?

If I need to I will post a copy of the code.

Thank you in advance!!