Niall@Manulife Posted March 22, 2005 Report Share Posted March 22, 2005 Error occurred when upgraded to XP from NT. When opening an excel file that has links to a second file, a window pops up asking "The workbook you opened contains automatic links........do you want to update links. Yes/No". I used to simply mouse move and left click. No longer works. Tried mouse move and text type enter, mouse move and text type Y. Physically using my keyboard or mouse works, but using software code does not? Seems as though this generic "Microsoft Excel" window takes over and locks all commands? I tried flipping out of Excel to Word and then back, hopng it may trigger some sort of activation, but excel would still sit there waiting for input "Yes/No". Any suggestions? Thanks. Quote Link to comment Share on other sites More sharing options...
randallc Posted March 23, 2005 Report Share Posted March 23, 2005 HiNiall, I have found in Word 2000 on that i need <Alt>y for this quite often, but I have not conquered it in a reproducible way. this works in word when it wants to open an Excel Link; I am not sure in Excel? (re-program window Name and Control.....?) And ? overkill; hey, it works! Get Control %C1% (Microsoft Office Word: Button)Wait For Window Title: "Microsoft Office Word" OR Wait for Control %C1% to become enabled Set Focus to %C1% Text Type: <ALT>y <GETCONTROL:01:WINWORD.EXE:002:#32770Microsoft Office WordButton&Yes><WAITWIN2:000010:000000:Microsoft Office Word><OR><WAITCONTROL:000010:000000:01:03><SETFOCUS:01><TEXTTYPE:<ALT>y> Not very logical; Let me know if you win! Randall Quote Link to comment Share on other sites More sharing options...
Niall@Manulife Posted March 23, 2005 Author Report Share Posted March 23, 2005 Randall, Thanks. Using capture works. Since the pop-up window has a generic title, I am still concerned I may grab the wrong window. Does Capture default to the window at the highest level, or on top of the rest? Quote Link to comment Share on other sites More sharing options...
randallc Posted March 23, 2005 Report Share Posted March 23, 2005 Maybe someone else knows! - Can you tell if the "Control Details" are different if you capture them on the different prompts? - if, so, ME is waiting for the control, so the Window title might not matter; if the converse, ? still a problem? Is it only working now because you use "ALT-y" anyway, rather than anything to do with the capture? Best, Randall 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.