Save As with multiple dates

[twckfa16]

Hello - probably an easy one for most of you

- Trying to use SaveAs with multiple dates.
- mon and sun are strings.
- The file should be saved as Report_1_07_29_2013_to_08_04_2013.xls

Please Login or Register  to view this content.

Thank you.

[NickyC]

Hi

It would help to have a bit more information. How will the macro identify what dates to use - is it from today for the next 7 days, the current work week, the week previously, etc

Also, is it always the same days of the week (Mon-Sun etc) or can it vary?

[twckfa16]

Thank you for your response.

This is what I did to identify what the previous monday and sunday are:

Please Login or Register  to view this content.

*Note that I have only 2 instances so far


And the last part is to save the file based on the mon and sun strings:

Please Login or Register  to view this content.

But I'm getting an end of statement error.

Thanks,

Mark

[NickyC]

Hi
I think all you are missing in your code is an ampersand before "to " in your saveas formula

Please Login or Register  to view this content.

this slight modification should work whatever day of the week you use the macro:

Please Login or Register  to view this content.