vba code to open excel file name in previous weekday date

[prabhuduraraj09]

Dear all,

I have a Question and would really need help to code it.

i need to open previous week day file always. File name would be like eg, summary22032014.xlsx. say i open this file on 23032014.

So everyday i would need to open previous day file. via vba code......i use below code.

The problem is if i execute this code on monday, This code searches for file on previous day date , that is on sunday date.
I need vba code to be corrected to search for file name dated should be logically Friday.

if i execute vba code on Tuesday, it should get file name dated on Monday. and it also should meet....if i execute on monday it should logically search file name
date for Friday. Not a weekend date.

How could i accomplish this.........please help

[SamT]

Please Login or Register  to view this content.