Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I wrote:
Sub compare() Dim monday As Workbook, sunday As Workbook, target As Worksheet Set target = ActiveSheet Set monday = Workbooks.Open("D:\Monday 00-01.xlsx", ReadOnly:=True, _ AddToMru:=False) Set sunday = Workbooks.Open("D:\Sunday 11-59.xlsx", ReadOnly:=True, _ AddToMru:=False) target.Range("A1").Value = sunday.ActiveSheet.Range("A1").Value - _ monday.ActiveSheet.Range("A1").Value monday.Close sunday.Close Set monday = Nothing Set sunday = Nothing End Sub I forgot to mention, replace "A1" in target with the cell you want the results placed in, and replace "A1" in sunday and monday with the address of the source data. -- You people have the morals of guinea pigs! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
MS Excel 2007 bug in difference between time | Excel Discussion (Misc queries) | |||
subtract the time difference from another time difference | Excel Discussion (Misc queries) | |||
Time difference calculations, daylight savings time, Excel | Excel Discussion (Misc queries) | |||
Negative time should be allowed in Excel, eg time difference | Excel Discussion (Misc queries) | |||
Cell formats, and time difference | Excel Discussion (Misc queries) |