STore the data in another workbook without opening it

Hi guys

I am writing the following code in a workbook names sample1 . This is basically a search form designed to capture any details from the excel sheet. Now what I want is to record what each user search and store the data in another workbook without opening it.I am writing the following code but when the user press enter button then it opens up the other workbook.

Please Login or Register  to view this content.

CAn anyone please figure it out.

Thanks

It sound rather sneaky: is the user aware of these actions and does s/he agree with it?
You'd better use 'Open', 'for append'
You can't write in a closed file. You can in an invisible one.