Mooseman60
10-28-2010, 04:56 AM
Can someone give me the code for the following
I have a userform with 3 textboxes to add employee details ie: First Name, Surname, Hourly Rate which needs to be saved to a worksheet called EmployeeDetails in a separate workbook called Defined Name List.xls in a folder named Project Data
The file path is MyDir = "C\Users\Doug\Project Data\Defined Name List".
I was able to get it to save to the worksheet when it was in the same workbook but not sure how to get it to save in the separate workbook
Any help would be appreciated:banghead:
I have a userform with 3 textboxes to add employee details ie: First Name, Surname, Hourly Rate which needs to be saved to a worksheet called EmployeeDetails in a separate workbook called Defined Name List.xls in a folder named Project Data
The file path is MyDir = "C\Users\Doug\Project Data\Defined Name List".
I was able to get it to save to the worksheet when it was in the same workbook but not sure how to get it to save in the separate workbook
Any help would be appreciated:banghead: