Open multiples workbooks in exact order
Hi guys,
So, I work with several workbooks opened at the same time on a daily basis and I'm used to work with them in a specific order (the order they are displayed in the taskbar).
It is simple to get VBA to open them, but is there a way to open them in an exact sequence so the display order is exactly the one I want?
I've tried to add waiting seconds between the commands, call different individual commands but nothing seams to work... they open in an apparently disorder
My task bar does not display the workbooks as the primary view, but when I hover the mouse on the Excel icon on the taskbar it shows the files in exactly the order that I opened them. I am using xl2013 and all previous versions that I have used displayed the files in the order they were opened, as well as automatically indexing them according to that same order. You can either list the workbooks in a range on a worksheet and use that list to open the files with a loop in a macro, or use an array within the macro to do the same thing. If you add or delete files, I would suggest you use the list on a worksheet method.
Well, I went to control panel and changed my task bar so it would display the labels for each open window and it still shows the workbooks in the order that they are opened.
Last edited by JLGWhiz; 09-12-2018 at 01:59 PM.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
Hi no-Fate
It looks like things changed in Windows 10. See if this site gets you closer to an answer.
https://superuser.com/questions/9475...-taskbar-items
Perhaps Jumplists are what you need to use instead?
https://www.addictivetips.com/window...in-windows-10/
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hi,
Just to make things more clear, my taskbar buttons are not combined in purpose, so multiple workbooks are displayed individually:
screenshot.JPG
If I open them manually, one by one, as shown in the attached image, they are obviously displayed in the opened order.
My problem is that, when trying to open them all using a VBA command, even if in the desired order, excel seams to open them randomly (I believe that the ones faster to load are opening faster, therefore breaking the desired order).
So, is there any way to force the VBA to fully open workbook1 and only then move to workbook2 and so on?
Thank you.
Hi,
Have you tried to put VBA in each of the individual workbooks that will open the next one in order? Is the order of opening these always the same or does it change?
Another suggestion is to put the VBA command of "DoEvents" in your code so it will finish the Open command before moving on to the next file.
See this site to see other possible ways of waiting for things to finish.
https://analystcave.com/vba-sleep-vs-wait/
Hi Marvin,Originally Posted by MarvinP
Thank you! This actually did the trick.
Although, can't understand why, but I had to wrote the workbooks order upside down so it actually open them the right way... whatever. It is giving me what I need and I'm satisfied with that.
Cheers!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks