Open Workbook Vba Visible. That is the way I do it (with the Excel. But now, even tho it does launch Excel, as seen in the task manager, it doesn't show the spreadsheet on screen.
Re: Open and Hide a Workbook. This code works great for opening the source workbook, but how do I set it back to normal and close it at the end of the code? Second, I suggest using the code that I posted.
One of the substantial things about VBA is it doesn't limit its work in the same workbook rather we can.
The file open dialog type is pretty simple VBA to get started and there are many great options to tailor it to your needs.
VBA Examples to Open or Close Workbooks - Open Workbook, Open File Dialog, Close Without Saving, Close and Save w/o prompt, Close all Workbooks, & more. Insert a new module from Insert menu. You can get immediate free access to this example workbook by subscribing to the Power Spreadsheets Newsletter.