>Is there a way to open an excel file, that happens to be linked to another file, without excel throwing the dialog "this workbook contains automatic links ... do you want to update" ? I tried .DisplayAlerts=.F., but still get the dialog.
>
>Chet
Hi Chet,
The code sample below will open the Excel workbook by passing the Excel dialog:
oExcel = CREATEOBJECT('Excel.Application')
oWorkbook = oExcel.Workbooks.Open('MYWORKBOOK.XLS',0)
oExcel.VISIBLE = .T.
Hope this helps,