Does anyone know how to programmatically update links in
an Excel Workbook **Saved as .htm (Excel format still,
but .htm)*** (without alerts, and the file must be closed
afterward.
The file contains links to another workbook and functions
such as =now() -- perfect to test if it's updating.

I thought I should simply open the file, save it then
close it. My strategy, however, does not work so simply.

Here's basically what I do.

Dim objExcel As New Excel.Application()
objExcel.Workbooks.Open("C:\Samia.xls", True, False)
objExcel.DisplayAlerts = False
objExcel.Workbooks.Close()
objExcel = Nothing

the section parameter of workbooks.open is UpdateLinks as
Object... doesn't putting True make it Update the links???

Result: links are not updated.

Thanks.

Samia.