I have two spreadsheet's. Test1.xls which is on my C:
Drive and another spreadsheet Test2.xls which is on my H:
Drive both spreadsheets are in a file called temp.
The spreadsheet on my C: Drive contains a user form that
the user completes and then clicks on a button. I want
that information to be put on the spreadsheet on my H:\
drive.

For example I have a field on the form that the user
inserts the date (txtdate) when they click on a macro I
want it to take the date off the user form and insert it
into cell A2 on spreadsheet H:\temp\test2.xls.

I have asked before but nothing seems to work........