How to re-display Excel after opening and closing a Word document
Hi All,
I am using Excel 2010, 32 bit.
I use a button on an Excel worksheet to run a macro which minimises Excel (Application.WindowState = xlMinimized) and then opens MS Word and displays a document. That all works just fine. What I can't figure out is how to re-display the Excel worksheet after closing the Word document. Of course I can simply click on the Excel icon on the taskbar, but I would prefer if the process could be automated so that users are returned to the Excel worksheet whence they came. Any help would be much appreciated.
Best regards.