Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Alt-Tab, Switch Focus, multiple instances of excel
That is totally cool, "watch window".... me likey Ok, so far I am able to activate a particular instance and I can "sendkeys" to it, but when I try to do anything with VBA code it just does the code on my VBAcode based spreadsheet. So this code will only return the filenames of the instance...- prudge
- Post #9
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Alt-Tab, Switch Focus, multiple instances of excel
It seems to be hit or miss. Some people are using Firefox, other are using Opera. I use opera and any spreadsheet always opens in a new instance. I haven't really looked at the settings in each program, but asking the company to switch settings in whatever program their using will be difficult...- prudge
- Post #7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Alt-Tab, Switch Focus, multiple instances of excel
It seems like no one has an answer for this. And I would think it's a fairly common issue. Circumstance: The user will open the files from their browser so this creates new instances of Excel. The user will choose which file they wish to work on from a Combobox that has been populated with the...- prudge
- Thread
- Replies: 9
- Forum: VBA Visual Basic for Applications (Microsoft)
