S
Samia
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.
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.