Adding data to a closed workbook

[surajitbose]

Thanks in advance

I have created a excel program with two workbook.
Workbook1 holds all the userform to add data
Workbook2 is the database
Basically I store all data to WorkBook2 through userforms in WorkBook1. So far to add data to database(WorkBook2) I open the workBook2 along with WorkBook1 and close it when I close the WorkBook1. and working perfectly.

Is there any way to put data into WorkBook2 without opening it. Application.Screenupdating is not not my choice.

Thanks again

This is a cross post and Link to original post

[Hawkeye16]

Yes, apparently there is.

[romperstomper]

Yes - you can use ADO to write to a closed workbook. You haven't given any details to work with so here's a generic example:

Please Login or Register  to view this content.

[Hawkeye16]

I stand corrected. So you just need to treat the workbook as a database and use a database connection and SQL statement to write to it without opening, interesting.