Trying to run a report using system day/date

[RunTime91]

Hello All ~

I am trying to have excel run a report based on the day of the week.

I have tried eleventeenhundred iterations of:

"If Weekday(Today()) = vbWednesday Then..."

The goal here is to not reference a cell with today's date, but rather have excel use its own system day/date to recognize, upon shutting down, if today is a "Wednesday" then run this report.

Any help would be greatly appreciated.

 

[Drrellik]

=WEEKDAY(TODAY()) will return a value of 3. so =if(WEEKDAY(TODAY())=3,run report,don't run or nothing)

hope that helps

3= Wenesday

 

[RunTime91]

=WEEKDAY(TODAY()) will return a value of 3. so =if(WEEKDAY(TODAY())=3,run report,don't run or nothing)

hope that helps

3= Wenesday

Drrellik ~ Thanks for chiming in ~

I tried and played around with different versions of the following:

If Weekday(Today()) = 3 Then
    'Run Report'
End If

but each time I get a "Subscript out of range" error


On another note,

I tried the following:

If Weekday(Now) = 3 Then
    'Run Report'
End If

And although it seems this method recognizes 4 as Wednesday it works - or at lease it appears to be working

Thoughts?

 

[Drrellik]

my apologies, you are looking for some VBA for this. I was giving you a formula in an IF statement IF this = that, do this, if not do this.

I am not quite up to speed on VBA but I am learning. maybe someone else can help from here.