Hi Guys,
When i am saving workbook and opening it in another instance it is always opened in my main screen.
Most of the time i am using 2nd screen and want to open excel in the 2 monitor after closing.
Code:
Set wb = Workbooks.Open(path & "\" & NameWbResult & ".csv")
always open in 1st monitor.
What i want to do is to remember left and top dimentions of windows and bring them up.
i tried with :
but not working.
Please Login or Register to view this content.
Anyone has idea how to solve?
Jacek
I'm not sure if this will help, but you can tell Windows via Display Settings which the main display of the two should be, then you will find that apps open on the designated display.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi,
can you say more about it ?
I will try but still would love to see VBA solution.
Jacek
Can you not just open the Display Settings dialog, scroll down and find the aforementioned option? You don't need a step-by-step for that, surely?
If you do, then right-click the desktop and choose Display Settings, then select the screen you want to make your main display. Then scroll down and tick where it says "Make this my main display".
this is not what i meant.
thanks
Jacek
OK, so what did you mean when you said this:
in response to this:can you say more about it ?
Sorry, but I am not a mind reader.you can tell Windows via Display Settings which the main display of the two should be, then you will find that apps open on the designated display
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks