Disabling External Links Dialog Box
Does anybody know how to do this?
Through VB, I create an instance of Excel. Then, I set the display alerts, interactive, and screenupdating properties to false.
Then, I loop through my workbooks and do my processing.
I'm trying to write this so it can run 100% automated (Unattended Execution).
When my program comes across a workbook that has external links to other Excel Workbooks, that dialog box still comes up asking the user if they want to update the data from external links. I want to turn this feature off so my program keeps running by itself.
Any help on this would be greatly appreciated...