Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding last Date Report
Hi,
I save WIP Reports in a Hist Folder every few days, So for example,my code will save today's report as "WIP 16-12-04", it should then open the last WIP report in the folder (e.g. WIP 13-12-04) and compare the 2 for changes, I need code which will find and open the last report and insert the workbook name in ******* below. Thanks for any help Sub desmond() 'Dim i, j ThisWorkbook.SaveAs "c:\Hist\WIP " & Format(Date, "dd-mm-yy") Worksheets.Add.Name = "Changes" ............................................ For i = 1 To 100 For j = 1 To 100 If Worksheets("Jobs").Cells(i, j) <Workbooks("*****"). Worksheets("Jobs").Cells(i, j) Then .................... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding a Date 90 days previous to present date | Excel Worksheet Functions | |||
report date - date rec.ved=days late, but how to rid dates complet | Excel Worksheet Functions | |||
Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
finding a date/time in a list that is closest to an existing date/ | Excel Discussion (Misc queries) | |||
Finding the Monday date based on a different date in same week | Excel Worksheet Functions |