Allen Wyatt's Excel tips

Updating Automatically When Opening Under Macro Control

If your workbook contains links, you are normally given the opportunity to update those links when you open the workbook. When opening the workbook from within a macro, you probably don't want Excel to ask about updating the links. Here's how to stop Excel's normally inquisitive nature.

Read this ExcelTip: Updating Automatically When Opening Under Macro Control
Microsoft Excel Tips - Learn Excel Faster!