Hi Experts - I am using the code provided in the solution to the question below to search for the current date and time in PDF documents. Basically if today's date is found, store the associated time in a variable to be used in the parent code.
I need similar code to search through an Excel spreadsheet for today's date and a time and store the time in 24 hour format in a variable labled "xlsTime". The date and time can be in the same cell or separate cells.
Ultimately, the goal of this function is to compare the date/time in a spreadsheet to the date and time stored in other variables (RSdate & RStime) and return False if the date/time in the spreadsheet are less than RSdate & RStime.
I have attached a few example spreadsheets. In the 322_BoA spreadsheet, I highlighted the date/time; they are in the number format instead of a date & time format. 322-BoACorr3-10140750-.xls clrates.xls 295-NYCB1-10140830-.xls