Closing a workbook

[SAsplin]

Hi folks -

I have an ActiveWorkbook.Close code but as the workbook closes it comes up with a message box:

"This workbook contains one or more links that cannot be updated"
To change the source links, click Edit Links
To leave the links as is, click Continue

Continue Edit Links....

Is there a line of code I can add to automatically select the 'Continue' option?

Thanks

Steve

[royUK]

Try adding this at the start of Before Close

Application.AskToUpdateLinks = False

[SAsplin]

Hi Roy -

Unfortunately that bit of code didn't work.

Steve

[Jack in the UK]

Post the code so far in ActiveWorkbook.Close

[SAsplin]

Thanks folks -

I've worked it out. As with most things it was quite simple in the end:

Workbooks.Open Filename:="fullpath", Password:="****", UpdateLinks:=0

Cheers

Steve

[Jack in the UK]

Sub myUpDate_LINKS()

'// jiuk
'// Call this in the close procedure ie
'// Call myUpDate_LINKS

    Workbooks.Open Filename:="c:\Dir\youFile.xls", _
            UpdateLinks:=True
    
    Exit Sub
                        
End Sub