Application.DisplayAlerts problem

[craigexcel]

Previously the setting of "Application.DisplayAlerts = False" was working fine when my code used a specific reference to open the target workbook:

Workbooks.Open Filename:= _
"Z:\Finance\Monthend Files\2007 Actual\2007 Flash\" & FLASH_workbook & ".xls" _
, UpdateLinks:=0

However, I changed the code to open the target workbook, by opening a dialog box to allow the user to select the specific workbook from the available files:

Target_FLASH_Path_and_File_name = Application.GetOpenFilename("Excel-files,*.xls", , "Please select the file to open")
Workbooks.Open (Target_FLASH_Path_and_File_name)

Now the prompt to 'update links' (to external sources) appears each time I open the target workbook. Is there a way to modify the code to open the target workbook so the 'update' dialog box is bypassed as it was originally?

 

[xenou]

Hi:

Sub test()
Dim Target_FLASH_Path_and_File_name As String
Target_FLASH_Path_and_File_name = "Book1.xls"

Workbooks.Open Filename:=Target_FLASH_Path_and_File_name, UpdateLinks:=0
End Sub

Don't you just need to add the update links option to your open method in the new routine? Regards.

 

[craigexcel]

Alexander,
Thanks for your reply. That worked perfectly! I simply overlooked that detail.