bypass opening workbook prompts

Did you try:

Application.DisplayAlerts = False

The enable macros confirmation dialogue is part of the security process in Excel. The options are to set the Security Level to low (not recommended), digitally sign the workbook, or save the workbook to a "trusted location".

With regard to updating links:

Workbooks.Open Method
http://msdn.microsoft.com/en-us/libr.../ff194819.aspx

UpdateLinks
Specifies the way external references (links) in the file, such as the reference to a range in the Budget.xls workbook in the following formula =SUM([Budget.xls]Annual!C10:C25), are updated. If this argument is omitted, the user is prompted to specify how links will be updated. For more information about the values used by this parameter, see the Remarks section. If Microsoft Excel is opening a file in the WKS, WK1, or WK3 format and the UpdateLinks argument is 0, no charts are created; otherwise Microsoft Excel generates charts from the graphs attached to the file

You can specify one of the following values in the UpdateLinks parameter to determine whether external references (links) are updated when the workbook is opened.

Value Meaning
0 External references (links) will not be updated when the workbook is opened.
3 External references (links) will be updated when the workbook is opened.

Regards, TMS

you shouldn't generally see macro prompts if you are opening a workbook with code (since you're already running code!) but for the links you can use

workbooks.open filename:="some file.xls", updatelinks:=false

I am faced with a further similar problem. The file I need to copy data from is already opened. Which means, I can either,

1. activate it. with

Workbooks("FILE311012.xls").Activate

problem is, filename is not static. i have created a dynamic cell that contains filename in A1, so i tried

Workbooks("A1").Activate

no luck

Alternatively

2. I can use a command to reopen it. but a prompt comes up in which i dnt know how to bypass, see attached.

That doesn't seem to be a "similar" question to me.

Whatever, try:

Workbooks(Range("A1")).Activate

Regards, TMS

Thanks for the rep.