Save form data to another file

[pilot]

On a protected sheet where 10 cells are unprotected for data entry, I want to capture each cell's entry and transfer that information into the first empty line of another file, preferably without opening the second file. I plan to disable the print capabilities at the menu and toolbar, relying instead on a Print button to be placed at the end of the form. In addition to printing, this button will activate the code that captures the data to the second file. Are there any special tricks to making this all happen without opening the second file? Would it be easier to stop screen updates, allow the second file to open, and enable updates after it has been saved and closed?

 

[white6174]

I am almost positve that it is not posible to wright to a closed file.
You will have to either open it or link to it.

steve w
This message was edited by white6174 on 2002-08-27 20:20