Excel vba to open other screen
Solved/Closed
Hello,
We are working on dual screens. I am writing a macro program in VBA. I need to open an existing excel file/workbook in a new excel application to be able to move it onto the other screen, so I could have two workbook open at the same time next to each other. I need to do it with the macro not manually.
Does anyone have a clue how to do it?
Thanks
Tibor
We are working on dual screens. I am writing a macro program in VBA. I need to open an existing excel file/workbook in a new excel application to be able to move it onto the other screen, so I could have two workbook open at the same time next to each other. I need to do it with the macro not manually.
Does anyone have a clue how to do it?
Thanks
Tibor
Related:
- Excel vba to open other screen
- Number to words in excel formula without vba - Guide
- Vba case like - Guide
- How to open excel in notepad - Guide
- Excel mod apk for pc - Download - Spreadsheets
- How to open vba in excel mac - 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!