Open Workbook Vba In Background. I don't want the front end user to be able to see the data. You can get immediate free access to this example workbook by subscribing to the Power Spreadsheets Newsletter.
There are several ways to start working with a workbook in Excel. You cannot work in Excel without opening the Excel. Just use the code below or something similar.
There are a lot of rarely used arguments for Workbooks.
You can choose to create a new workbook—either with a blank workbook or a predesigned template—or open an existing workbook.
Double click on This Workbook from the Project Explorer window. Unfortunately it shows the book in the taskbar first then hides. False (default) saves files against the language of Visual. 'Open the Excel workbook Set WB = Workbooks.