detlion1643
Board Regular
- Joined
- Nov 25, 2009
- Messages
- 164
I am using VBA code to basically update my workbooks from 3 specific workbooks. I have a code that I put in every new workbook I make that runs when the workbook is opened. This code opens 1 workbook and looks for data, then closes and opens another and looks for data, then closes and once more.
Everything runs fine, but opening each workbook then closing it gets annoying, and not sure if it's slower. But, is there a way to access a workbook without opening it.
Right now:
workbook("NAME").open
workbook("ORIGINAL").activate
**
workbook("NAME").close
x3
Everything runs fine, but opening each workbook then closing it gets annoying, and not sure if it's slower. But, is there a way to access a workbook without opening it.
Right now:
workbook("NAME").open
workbook("ORIGINAL").activate
**
workbook("NAME").close
x3