Use one file to accumulate cells on a second file(closed).

I want to improve my spreadsheet from accumulating entries in same cell using a single spreadheet. Please refer to my previous which came out successfull. thread:http://www.excelforum.com/showthread...ght=accumulate

I now have 2 spreadsheet files 1st for Daily Entries and 2nd Progressive Totals. Both files have identical formats.

How can I program it so that the while the Progress Totals file is closed, daily entries entered on the Daily Entrie file accumulates the corresponding cells in the Progress Total file?

In a word (or two), you can't. VBA can retrieve values from closed files, but to my knowledge, cannot change them.

Thankyou SHG for the prompt response. I knew it would be difficult but just decided to ask on the forum.

It's just that I want to keep track of the last entry I made? But not a big worry for now.

Thanks for your help.

Hi

May have found a way to do this.

1) Create a new workbook. In A1 enter H1. This is the column Heading. Save the file as c:\temp\a.xls
2) In a new open workbook, enter your input number in A1 (say 15). Insert a general module, and insert the code

Please Login or Register  to view this content.

Run the code.

Open a.xls and you should find that A2 contains 15. Shut down a.xls, and change the value in A1 from 15 to 20. Rerun the code. Open a.xls and you should find that A2 is now 35.

See how that goes, and see if it can be converted to suit your situation.

rylo