Find sht in wb with most current date & send automatically at certain times of the day.

[ANDREAAS]

Hi

I use the below code with a button in one of my workbooks and it works great (thanks to the person who wrote it by the way), but I need for it to be adapted for another workbook that I have where I want code to select a certain range of the sheet named with the most current date (format : 29-01-15) and then mail the user updated copy at 10:00, 12:00, 14:00 and 17:00.

Any help will be much appreciated.

Please Login or Register  to view this content.

[ANDREAAS]

Bump no reply

[ANDREAAS]

Ok, so I got the send at certain times sorted with application.ontime in wb_open. I'm thinking if I set source in the above code to active workbook, then I only need help with the code to make the sheet named as the most recent date active. My sheets are all named as dates with mm-dd-yy format.
Any ideas how to activate the sheet named as the most current date when the macro is run?

[ANDREAAS]

I think I'm inching towards the answer, but just need a little more help to get there. Here's what I've got so far, but can't get it to work properly...

Please Login or Register  to view this content.

[ANDREAAS]

Bump no reply

[ANDREAAS]

Bump no reply

[ANDREAAS]

Bump no reply

[ANDREAAS]

Bump no reply

[ANDREAAS]

Bump no reply

[ANDREAAS]

Bump no reply

[ANDREAAS]

Bump no reply

[ANDREAAS]

Bump no reply

[ANDREAAS]

Bump no reply

[ANDREAAS]

Ok, so the code below gets me a bit closer...... I think......but I cannot get it to find the correct format i.e. sheet named for today with a format of dd-mm-yy

Please Login or Register  to view this content.

Please help. I know the answer is probably so simple that I could kick myself, but I'm just not getting there.....

[ANDREAAS]

essentially I've got a bunch of sheets, 31 to be precise, with dates as names, 01-05-15 to 31-05-15 today is 22-05-15, so the code needs to make the sheet with the name 22-05-15 active and then send it as a mail.

Hope this explains it a bit better?

[ANDREAAS]

Bump no reply

[ANDREAAS]

Bump no reply

[FDibbins]

I have asked for help on this

[protonLeah]

Please Login or Register  to view this content.