Help

[Glenn]

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........

 

[Paul]

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........

As you want a macro, try posting in the Excel programming newsgroup.

 

[Bob Phillips]

answered in the programming group.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)