How can I load a workbook without the user seing it? Also, how could I load a spreedsheet in this manner as well?
For now, the main workbook does this to access the data information from the second workbook....
1. Open data workbook
2. Copy data spreedsheet
3. Hide data spreedsheet
4. Close data workbook
....works, but when the main workbook opens you can also see the second workbook open and all that mess while it's working. I'd like the user to open the main workbook and have the needed spreedsheet added without the visual display.
Reply With Quote