Jump to content
Macro Express Forums

Open Excel File With Links


Niall@Manulife
 Share

Recommended Posts

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...