Hi all,
I was wondering if the following is actually possible:-
I can open a file I have created previously today with VB using the following code with no problem:
strdate = Format(Now, "dd-mmmm-yyyy")
ChDir "E:\TAT"
Workbooks.Open Filename:= _
"E:\TAT\Report " & strdate & ".xls"
I would like to open a workbook from exactly 7 days ago from the same folder but I'm not sure if its possible.
Can anyone shed any light/help?!! Please?
Many Thanks
Tony
I was wondering if the following is actually possible:-
I can open a file I have created previously today with VB using the following code with no problem:
strdate = Format(Now, "dd-mmmm-yyyy")
ChDir "E:\TAT"
Workbooks.Open Filename:= _
"E:\TAT\Report " & strdate & ".xls"
I would like to open a workbook from exactly 7 days ago from the same folder but I'm not sure if its possible.
Can anyone shed any light/help?!! Please?
Many Thanks
Tony