Im trying to open a file which is named the previous working days date.
For example on Monday the date was 18-07-11. So the file i wanted to open was Fridays file which was named 15-07-11.xls as per fridays date.
Im trying to write a macro that reads todays date, calculates the previous working days date / stores the date in a variable, use whats stored in the variable (to create the filename) to open the previous working days file.
Bookmarks