Refreshing an OLE object

M

Matt

I have a linked OLE object in a form. I use the code below on form load,
however the OLE object is not refreshing properly. The update option
property is set to automatic.

Set xls = New Excel.Application
xls.Visible = False

Set wk = xls.Workbooks.Open("c:\ExcelGraph", True)
 
Top