Excel vba to open other screen [Solved/Closed]

Tibor - Mar 10, 2010 at 11:24 AM - Latest reply:  holycow
- Apr 13, 2013 at 05:57 AM
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
See more 

5 replies

Best answer
rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - Mar 10, 2010 at 12:57 PM
3
Thank you
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

Thank you, rizvisa1 3

Something to say? Add comment

CCM has helped 1901 users this month

Dear rizvisa1,

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
rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen > Tibor - Mar 11, 2010 at 10:51 AM
taskID = Shell("excel.exe ""C:\Users\haadi\Downloads\WO sample.xlsm""", 3)
Tibor > rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - Mar 12, 2010 at 03:09 AM
It worked!

YOU ARE A SUPERSTAR!

Thanks a lot!
1
Thank you
Awesome that just worked for me too. Thank you very much.