get data from closed workbook then add to current cell then sum

[jmendenhall1960]

So what I am tring to do is to get results (a number) from a cell which is a result of a formula. This is in a workbook that is not open but in the same network drive and folder as active workbook. I have searched past posts and have had no luck. This is the formula I have tried. ='network/CINRPC1/users/CINMendej2/MasterCopy of Cynthia's Schedule PP 12 and 13/sheet1'!AE4+AF4
. I get a formula error. What I want to do is get number from sheet1!AF4 (which is the result of a formula) and then add (sum) to active sheet AE4 . I have tried =SUM then click on the workbook to open and this did not work either. If this is possible Thanks for looking and your help.

 

[Stildawn]

You can do it via VBA code like this:

With GetObject("c:\test path\other workbook.xls")
    Thisworkbook.Activesheet.Range("AE5") = .Sheets(Sheet1").Range("AF4") + Thisworkbook.Activesheet.Range("AE4")
    .Close False
End With

Totally untested haha, but should work if I wrote it out correctly.

 

[jmendenhall1960]

I have to do this for AE4: AE39 (35) different rows. Will this work for each one. I have to add the scheduled OT hours from last month schedule to this months schedule for each person.

You can do it via VBA code like this:

With GetObject("c:\test path\other workbook.xls")
    Thisworkbook.Activesheet.Range("AE5") = .Sheets(Sheet1").Range("AF4") + Thisworkbook.Activesheet.Range("AE4")
    .Close False
End With

Totally untested haha, but should work if I wrote it out correctly.