Change date on file from pop up each time I run macro

[jonathan.haynes]

Hi,

So i'm running a macro which opens a file. I will be running this macro everyday and the date of the file changes everyday.

This is my current code:

Please Login or Register  to view this content.

Please note "SM Daily Report 23102013" is the workbook that is currently open and where the macros are stored.

Everywhere in the macro that says "23102013" I need to somehow have an option to change that everytime I run the macro, or have an option to select a date. Tomorrow all the files will be names 24102013.

Any thoughts on this?

Thanks

[jonathan.haynes]

I'm guessing is it possible to simply find and replace a macro?

Either that or somehow use a reference to TODAY() as it will only be used on today's data.

Cheers

[jaslake]

try

Please Login or Register  to view this content.

[jonathan.haynes]

Ok.. where do I put that? In a new macro it'self?

I'm creating this for my peers who don't know how to use VB. So to make it customer friendly ideally I need to have something on an excel worksheet where you either click a button and enter the date, or type the date into a cell and the macro populates from that cell.

Make sense?

Cheers

[jaslake]

Hi jonathan

This is what I had in mind...no button required

Please Login or Register  to view this content.

[jonathan.haynes]

Ahh this works brilliantly, thanks!

I'm doing this with several files and one of the dates is the day before today, so is there a way of doing the same as above but saying YESTERDAY rather than TODAY? (for the workbook only).

Cheers!

[jaslake]

Hi jonathan

Try this

Please Login or Register  to view this content.

[jonathan.haynes]

Great, thanks! Great help

[jaslake]

You're welcome...glad I could help. Thanks for the Rep.