+ Reply to Thread
Results 1 to 2 of 2

Reading Date from text file and compare today date

  1. #1
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Post Reading Date from text file and compare today date

    hi,
    i am trying to modify this code,
    i want to compare today date with text file's date if today date is greater then or equal with text file date then close the workbook,

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    above method is showing this message
    Sample.JPG
    Last edited by HaroonSid; 12-29-2017 at 01:55 AM.
    Use Code-Tags for showing your code :
    Please mark your question Solved if there has been offered a solution that works fine for you
    If You like solutions provided by anyone, feel free to add reputation using STAR *

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,239

    Re: Reading Date from text file and compare today date

    Come on now HaroonSid...After all your posts you should know that a simple sample upload will make life so much easier for all of us...

    Anyway...
    For now, change this
    Please Login or Register  to view this content.
    to

    Please Login or Register  to view this content.
    Last edited by sintek; 12-29-2017 at 03:17 AM.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

+ 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. Macro: check today date with start date and open a file in stored location
    By Topa2 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-10-2016, 11:39 AM
  2. Problem reading in text file handling date
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-22-2015, 11:52 AM
  3. [SOLVED] count occurrenced of today's date in cells where the date is imbedded in other text
    By ItzikM in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-25-2015, 10:51 PM
  4. [SOLVED] Formula to compare date (including month and year) from a listed date to today's date
    By mhewitson15 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-11-2014, 05:31 PM
  5. [SOLVED] Prefill text box in userform with today's date but allow user to enter unique date
    By moosetales in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-02-2014, 09:17 AM
  6. Convert text mm-dd-yy date from external file & compare to TODAY()
    By Frontier in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-02-2014, 01:43 PM
  7. How to compare today's date to a cell on VBA?
    By Sivangen in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-04-2006, 07:30 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