Question Ignoring 'Contains Link' Message

[bathyphen]

I have got some VB.net code that opens up an excel spreadsheets, checks all the vba modules and finds & replaces a certain string for another.

My code just hangs though if the Excel file 'Contains Links' and I have to press Continue on the m up message before my code will continue.

Is there any way I can handle this message, to ignore it, do my changes & save, without it breaking the spreadsheet, or even handle it so I at least ignore the file completely?

 

[ggunter]

Set "DisplayAlerts" to False when you open the workbook.

Just remember to reset it back to True before you close it.

 

[bathyphen]

Thank you for replying.
I knew it was something like that as I am pretty fluent in VBA but I just couldn't figure out how to call in from VB.Net.

But I have got it now, thank you so much