Value | Meaning |
0 | Doesn't update any references. |
1 | Updates external references but not remote references. |
2 | Updates remote references but not external references. |
3 | Updates both remote and external references. |
Value | Delimiter |
1 | Tabs |
2 | Commas |
3 | Spaces |
4 | Semicolons |
5 | Nothing |
6 | Custom character (see the Delimiter argument) |
Workbooks.Open "Analysis.xls"
ActiveWorkbook.RunAutoMacros xlAutoOpen