User Form to Update data in Another workbook

[krishhi]

Hi Guys,

I have a workbook name called "Userinputs" with a User form in Sheet1 and the database is in sheet2. So, when the user Clilck on the Submit button, the data will update in Sheet2. It works fine.

But we want another way, that is, We will create another Excel File let say "Database.xls" in "E:\DailyReports\Firmdatabase\Database.xls". So, when the user click the Submit button in Userinputs, the data should update in Database.xls file.

Is there any way to achieve this task?

Please let me know, if i am not clear about my instructions.

Regards,

Krrish

[mohanvijay]

you can use the access database