Macro Saves & Names File with Current Date & Range

[BluTalon]

Hi, all,

This is sort of related the post below but with a slight twist.
http://www.excelforum.com/showthread...highlight=date

I would like to create a macro that saves and names a file with the current date and the day after. The code below works, but is somewhat limited.

Please Login or Register  to view this content.

What I want is for the macro to only input weekdays. In other words if I run the macro on Fri. 4/11, I want it to name the file "Schedule April 11 - April 14." In this case 4/14 is a Mon. So the macro skips the weekend dates.

Is there anyway for this to work? Any help would be greatly appreciated.

[jasoncw]

Will you always only be creating this file Mon-Fri? If so, you can define your variables as follows:

Please Login or Register  to view this content.

HTH

Jason

[BluTalon]

Yes. This particular report will only be created with a Mon-Fri date.

I tried the code you provided, and it totally worked. It was exactly what I needed. I was even able to use it as a template for another macro I was using. It fixed a similar problem there, too.

Thanks a lot!

[jasoncw]

Glad it helped.

Jason

[BluTalon]

Hi,

It's me again. So the code that jasoncw provided continues to work great, but I have noticed when it comes to the end of the month, the file is renamed with the same month.

So if I were to save it today 5/30 the file would be saved as "Schedule May 30 - May 2.xls" How can I get it to say "Schedule May 30 - June 2.xls" Basically at the end of the month, I would like it to get renamed with the following month included.

This is what I have so far.

Please Login or Register  to view this content.

Thanks!

[jasoncw]

See the added IF statement and new variable (MyMonth1) in red below that should correct this issue:

Please Login or Register  to view this content.

HTH

Jason

[BluTalon]

Wow! So fast.

Thanks a lot. It works great!