Auton open code

[not very bright dave]

I am opening a file, which when opened, asks me if I want to update links. I need some code to automatically say no. Is this possible? Any ideas?

Thanks in advance

Dave

 

[pcc]

you can set the argument 'updatelinks' to zero when using the open command eg

Workbooks.Open "ANALYSIS.XLS" updatelinks = 0

 

[not very bright dave]

Where do I put this code? When I put it in the workbook code of the workbook I'm trying to click 'no to autoupdate' in, it just asks me if I want to open the current workbook again! Any ideas?

Thanks

Dave

 

[not very bright dave]

Any ideas?

 

[pcc]

If you are opening the file manually then I don't know. The code I posted is for use when you are opening the file via VB.

also
Under tools>options>Edit tab there is an option for
'ask to update automatic links'

I have never used it but that may be the answer - try it and see

 

[not very bright dave]

pcc, you're a legend. Thanks