+ Reply to Thread
Results 1 to 19 of 19

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

  1. #1
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    360

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

    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.

  2. #2
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    360

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

    Bump no reply

  3. #3
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    360

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

    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?

  4. #4
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    360

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

    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.

  5. #5
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    360

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

    Bump no reply

  6. #6
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    360

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

    Bump no reply

  7. #7
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    360

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

    Bump no reply

  8. #8
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    360

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

    Bump no reply

  9. #9
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    360

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

    Bump no reply

  10. #10
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    360

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

    Bump no reply

  11. #11
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    360

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

    Bump no reply

  12. #12
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    360

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

    Bump no reply

  13. #13
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    360

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

    Bump no reply

  14. #14
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    360

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

    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.....

  15. #15
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    360

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

    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?

  16. #16
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    360

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

    Bump no reply

  17. #17
    Forum Contributor ANDREAAS's Avatar
    Join Date
    05-06-2013
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    360

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

    Bump no reply

  18. #18
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,095

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

    I have asked for help on this
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  19. #19
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,083

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

    Please Login or Register  to view this content.
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Send email automatically before due date
    By Kara_xy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-05-2013, 06:11 AM
  2. command button 1 (save as pdf named the current time and date . then send by email
    By guitarist00 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-02-2013, 09:43 AM
  3. Macro Loop Find Specific Times, Extract Date, Average Values of Times
    By ExcelQuestFL in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-25-2010, 02:50 PM
  4. [SOLVED] Can I automatically enter the current date or current time into a
    By Ben in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 10-19-2005, 11:05 AM
  5. give back times of current month automatically
    By Markus Scheible in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-01-2005, 11:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1