links auto update

[delta5555]

when a workbook opens and asks to update links from other workbooks, is there a way to select yes using a macro?

also is there a way in code to click on the active button on a form eg. enter/ok/import?

 

[dln]

On 2002-10-05 12:31, delta5555 wrote:
when a workbook opens and asks to update links from other workbooks, is there a way to select yes using a macro?

also is there a way in code to click on the active button on a form eg. enter/ok/import?

Is this one question or two - would be helpful to post/title the question(s) that way!

Open with Links:
You don't so much click "yes" after the fact, as anticipate the question:

Workbooks.Open(Filename:=strParametersFullFileNm, _
UpdateLinks:=3)
- there are other numeric codes - pls review in Help

Active form button:
When placing the command button, check the properties and set Default=True. Again check Help for any 'curlies'...

Regards,
=dn

 

[ROBINSYN]

Just found this. Worked for me. Can not remember name of source but it works great.

Open the template for editing and choose Tools, Options and on the Edit tab uncheck "Ask to update automatic links". Then save the template.

 

[imported_unknown]

(In ThisWorkbook code)

Private Sub Workbook_Open()
Application.AskToUpdateLinks = False
End Sub

updates without asking when opened...