I need some assistance to have a vba macro do the following:
1. I have workbook, and want a procedure that runs On_Open.
2. The procedure shows you the File_Open dialog box and you select your file. (but defaults the path of the open dialog to make it easier for the user - i.e H:\Macro\)
3. The program analyses the name of that file and decides to name it as the previous business day.
4. It then saves a copy of the file under that name (previous business day - i.e in the format like October 8 2013.xlsx)