Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - on a button event, open another closed file, post changes, close file
Really new to VBA but coming along.
I hope that this hasn't been addressed already in this forum, I looke but didn't find it ... The issue I can't resolve is this: I have a shared workbook wit multiple sheets, essentially counting instances of answers from list (lots of 'em) across all sheets. These are being summed in my 'summary sheet (countif). Upon a button event (available on each sheet), I a posting from the summary to the summary2 sheet ... using th following: Sub GetAns() Sheets("Summary2").Select Range("D5").Select Selection.Offset(0, 0) Application.Sum(Sheets("Summary").Range("D5").Valu e Sheets("Summary2").Range("D5").Value) Selection.Offset(1, 0) Application.Sum(Sheets("Summary").Range("D6").Valu e Sheets("Summary2").Range("D6").Value) .+ .+ Long story, but I have Summary (current tally) and Summary2 (tota tally) The thought is this - this book is to be shared by 50+ users who wil update it periodically yet constantly. What I would like to accomplish essentially, would be to to have 'summary2' as an external closed boo that accepts the posting from each save from the open books 'summary sheet ... using vba (ActiveWorkbook.Save) in my GetAns sub ... basically 'on save, add this value to that value in that book' ... 'that' book will be a running tally of all users answers ... Sorry, I hope this makes sense ... Can anyone help -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reference a closed filed from a cell and formula in an open file | Excel Worksheet Functions | |||
Move entire row of data from open to closed file by entering date | Excel Discussion (Misc queries) | |||
Macro to Open, then Close another File | Excel Discussion (Misc queries) | |||
VBAProject remains open after file is closed | Excel Discussion (Misc queries) | |||
Automate open file, update links, run macro, close and save file | Excel Programming |