Excel vba to open other screen
Solved/Closed
Related:
- Excel vba to open other screen
- Number to words in excel formula without vba - Guide
- Vba case like - Guide
- How to open vba in excel mac - Guide
- How to open excel in notepad - Guide
- Word full screen - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 10, 2010 at 12:57 PM
Mar 10, 2010 at 12:57 PM
if you want to start a new excel application (not the workbook only) then use
shell("excel.exe")
and if you want to open an excel file but not a new excel application window, then use
workbooks.Open
shell("excel.exe")
and if you want to open an excel file but not a new excel application window, then use
workbooks.Open
Mar 11, 2010 at 03:26 AM
I've tried these before. I can start new excel application and I know how to open a workbook. What I need is to open that workbook in the New excel application not in the existing one that I am running the macro from otherwise I can't use it on the other screen seperated from the workbook that has the macro within.
Any idea?
Thanks
Tibor
Mar 11, 2010 at 10:51 AM
Mar 12, 2010 at 03:09 AM
YOU ARE A SUPERSTAR!
Thanks a lot!