I'm embedding Excel in a
VB app, and I've found that when the user is editing the formula in a cell, that certain automation calls hang - they bring up
VB's Switch To/Retry/Cancel dialog. Is there any way to programmatically click the checkmark to get out of formula edit mode so that the document may manipulated? To reproduce, create a form with a button and a webbrowser control. Add the following code:
Private Sub Command1_Click()
Dim wb As Excel.Workbook
Dim ws As Excel.Worksheet
Dim w As Excel.Window
Set wb = WebBrowser1.Document
Set ws = wb.ActiveSheet
Set w = wb.Windows(1)
End Sub
Private Sub Form_Load()
WebBrowser1.Navigate2 "file:///C:/test.xls"
End Sub