Open Workbook Vba In Background. That is what I was doing first. You can set the opened workbook to an object, so that it is easy to refer your workbook to do further tasks.
Open (Path & Name & "Archive.xls"). Let me know if it works Sometimes I actually have a workbook open in the background while running a macro fetching data from it. Double click on This Workbook from the Project Explorer window.
When the workbook is already open, I.
You cannot work in Excel without opening the Excel.
You can get immediate free access to this example workbook by subscribing to the Power Spreadsheets Newsletter. Double click on This Workbook from the Project Explorer window. The most common operations in day to day life is to open an excel Workbooks when you are working with Excel.