I am very new to VBA and am looking for advice and direction on how I may accomplish this idea. I am wondering if it is possible in excel to have a master sheet (one we use daily of many sheets, I am hoping to understand enough to apply it to all of our daily data sheets) and have it do the following:
Upon opening the file it will:
A. Check to see if directory S:\\shared\name\subname\unit\datafolder\YYYY (Year Folder) exists if not create it.
B. Check YYYY Year folder to see if Month folder (MM YYYY) exists if not create it.
C. Check to see if date is entered in Cell “B4”. We reopen the file after it is created so it needs to retain the date if one is entered in cell “B4” and is opened at a later date for review.
D. Enter Date at cell “B4” (MM-DD-YYYY).
E. Rename new sheet from master file to Date (MM-DD-YYYY) SI Log.xlsm.
F. Auto Save file every 5 minutes. If opened on date after date on file, no updating of date is done.
I really have no Idea where to start. All help is appreciated! I do not have any workbook started yet to attach.
Bookmarks