Excel macro problem opening workbook with links 1

[owentmoore]

I have an excel macro that opens another workbook as part of the code. This works fine for the majority of my workbooks but for one workbook there are links in it. This means that whenever it opens it asks if I want to update the links - I don't - but I must now be present anytime the workbook opens to click no.

I have tried the following code which has not worked...

    Application.DisplayAlerts = False

...my code to open workbook...

    Application.DisplayAlerts = True

Does anyone know how I can avoid this dialog box popping up?

 

[arthurbr]

Please refer to forum707 for VBA problems, you will find more info there

Cheers

 

[Gavona]

You could also try looking in help:
expression.Open(FileName, UpdateLinks, ReadOnly, Format, Password, WriteResPassword, IgnoreReadOnlyRecommended, Origin, Delimiter, Editable, Notify, Converter, AddToMru, Local, CorruptLoad)......


Gavin

 

[owentmoore]

Thanks Gavin - should have checked the help first.

Owen