I'm pretty new at VBA so I could use some help with this.
I have a costumer name in cell A1 and I have a folder with different folders named after costumers (let's say folders named Batman,Superman,Spiderman,etc)
I want to press a button, which looks in this main folder after the name in cell A1 and open it. If it's not found I want a messagebox saying the folder was not found.
Long story short I want to put "Batman" in cell A1, press a button which looks for a folder named "Batman" in a specific location (D:\Export\Costumers) and opens it when found. If not found get an error message in a messagebox.
If anyone could help me out with this would be greatly appreciated.
Thanks in advance.