Screenupdating false when sending data from VBA userform to multiple workbooks

[scraigrobinson]

I have a main data entry userform that sends data to a few different workbooks. Currently it opens each workbook. The master "database" workbook is getting very large and cumbersome. Opening, transferring data, saving and closing is beginning to take way too long.
IF it is necessary to open each workbook, is it possible to do this in the background without disrupting the main userform input? I have tried some application.screenupdating = false but haven't gotten anywhere productive with it.

thanks for the help.

[JBeaucaire]

You could have your FORM actually open the workbook(s) in the background (hidden) when the form initializes, that way the data is available at all times pretty much instantly. Then when closing the form, you could have it save/close that hidden workbook, too.