Hello -
I know I'm asking a lot on this one, but as usual, I need some help.
I have a date in cell A1. B1 displays the day (ddd). What I need to do is based on the day e.g. tuesday, I need to go and email a file that was created for this date A1 -1. Is there a way to do this?
So if today is 1/27/05 and this date is in A1, I need the code that will open a file named blah1/26/05 and send it to a predefined email address.
I hope some of this makes sense.
thanks for your time,
Jim
I know I'm asking a lot on this one, but as usual, I need some help.
I have a date in cell A1. B1 displays the day (ddd). What I need to do is based on the day e.g. tuesday, I need to go and email a file that was created for this date A1 -1. Is there a way to do this?
So if today is 1/27/05 and this date is in A1, I need the code that will open a file named blah1/26/05 and send it to a predefined email address.
I hope some of this makes sense.
thanks for your time,
Jim