Rustywinger Posted September 6, 2007 Report Share Posted September 6, 2007 Hi all! I have multiple files open in Excel, and I want to go from a different application to a specific window open in Excel. Activate or Launch: "ReferringProviders" OR "ReferringProviders.xls" I have specified the exact file and the exact window, when launching this file from scratch, it opens the correct window, but if I switch applications and there is a different file open in the foreground of Excel, it will not switch to the file I want. I just can't figure it out. Any tips? Quote Link to comment Share on other sites More sharing options...
johnboy691 Posted September 6, 2007 Report Share Posted September 6, 2007 Rusty, know exactly what you mean. Our company utilizes excel with many different spreadsheets and other applications we have to move back and forth between. The only way we have been able to get around this is to open each spreadsheet in a seperate excel. Once two or three are open (along with other applications they automatically "stack" on the task bar so you don't see 4 or 5 different sessopms pf excel open, but there are. Open the first by opening the file and/or double clicking on an icon, etc. The for the second and consecutive speadsheets needed open go to Start and open a new excel. You can then use macro express commands to always find the correct spreadsheet you need. John Quote Link to comment Share on other sites More sharing options...
Cory Posted September 6, 2007 Report Share Posted September 6, 2007 There is also a prefercne in Excel to display each open file as it's own item in teh taskbar. Options > View > Windows in Taskbar Quote Link to comment Share on other sites More sharing options...
floyd Posted September 6, 2007 Report Share Posted September 6, 2007 I have multiple files open in Excel, and I want to go from a different application to a specific window open in Excel. Two questions: Which version of Excel are you using? When you say "specific window in Excel", do you mean a particular workbook sheet? Quote Link to comment Share on other sites More sharing options...
Rustywinger Posted September 7, 2007 Author Report Share Posted September 7, 2007 Floyd- 1- Excel v. 11.0.8142.0 2- Not a particular workbook sheet, however, that would also be some very handy knowledge to have. Right now I am trying to isolate a file open in Excel. Cory- I checked my prefs and "Windows in Taskbar" was enabled. You didn't specify what state you recommend this be. Johnnyboy- Nice workaround! But a little complicated because there are going to be 10 different people (paid hourly) using this macro file and not all are that... motivated to jump through too many hoops to get this working. Thanks everyone! Quote Link to comment Share on other sites More sharing options...
Cory Posted September 7, 2007 Report Share Posted September 7, 2007 Uhhhhh.... Well the option is a check box so if you see one item in the taskbar for all open Excel files do it the other way... :-) But to answer your question if it's checked teh individual open files appear as "Windows in Taskbar". That is multiple windows and therefore multiple icons on the taskbar. But of course they can still stack but I don't think that effects what you want ot do with ME. Quote Link to comment Share on other sites More sharing options...
Cory Posted September 7, 2007 Report Share Posted September 7, 2007 Oh, one other thing. You could probably check this option state in the registry and change it if need be if you have many users. Quote Link to comment Share on other sites More sharing options...
joe Posted September 13, 2007 Report Share Posted September 13, 2007 Added a solution for this problem to the Third-party Tools section. Quote Link to comment Share on other sites More sharing options...
johnboy691 Posted September 18, 2007 Report Share Posted September 18, 2007 You said: 2 - Not a particular workbook sheet, however, that would also be some very handy knowledge to have. Here is what I did. It's probably a long way around Robin Hood's barn, but it gets the job done. I open my excel spreadsheet. I have multiple sheets with data on them and want to copy/paste or move between them as necessary. To do this you need the sheet tab NAMES in variables. Let's say I'm in Sheet1 and want to go to Sheet9, I just have ME do the following: <TEXTTYPE:<F5>><MSD:250><TEXTTYPE:%T33%!$A$%T22%><MSD:250><TEXTTYPE:<NUMENTER>><MSD:250> %T33% is the name of the sheet, the A is the column I want it to go to and %T22% is the cell number. The !, $ are the excel requierments for finding a certain position. (I actually got the idea for this from a comment Cory said about something, thanks Cory) If you don't want to type the Sheet tab names into a variable you can have the macro grab them by doing the following: <REM2:Start Copy worksheet name><MSD:150><TEXTTYPE:<ALT>o><MSD:50><TEXTTYPE:h><MSD:50><TEXTTYPE:r><MSD:50><TEXTTYPE:<CTRLD>c<CTRLU>><MSD:50><TVAR2:33:03:><MSD:50><TEXTTYPE:<ARROW RIGHT>><MSD:50><TEXTTYPE:<NUMENTER>><REM2:End Copy worksheet name> Hope this helps or gives you your own ideas, John Quote Link to comment Share on other sites More sharing options...
Rustywinger Posted September 20, 2007 Author Report Share Posted September 20, 2007 Johnboy, I get more ideas from the great people in this forum than I know what to do with, but It's all going on my list because I see potential in almost everything posted here. I'll have to put in a proposal to the boss to dedicate more of my job to this stuff! :-) PS- Joe, Thanks for that fantastic fix! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.