Looking for some vba that will look for a specific file in a specific location and if it does not exist.... create the required folders and file. It is a .xls file. say we use, C:\folder1\folder2\ThisIsTheFile.xls If it does exist.... will PartyOn
It is a static file and will always need to exist on a users device in order for a process I am using in a procedure. Plan is to put this in the WorkbookOpen so it checks each time the file is opened. Thought that someone has probably done this before. Please advise and thanks.