when running the following code in the VS 2005 environment
(AxWebBrowser1 is a microsoft web browser):
Public Class Form1
Dim WB As Microsoft.Office.Interop.Excel.Workbook
Private Sub AxWebBrowser1_NavigateComplete2(ByVal sender As Object,
ByVal e As AxSHDocVw.DWebBrowserEvents2_NavigateComplete2Event) Handles
AxWebBrowser1.NavigateComplete2
WB = e.pDisp.Document
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
AxWebBrowser1.Navigate("c:\test.xls")
End Sub
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button2.Click
WB.Worksheets(1).Range("b4") = "AAA"
End Sub
End Class
I recieve the error :
Exception from HRESULT: 0x800A03EC
Please can anybody help?
tomerk@aman.co.il - 16 May 2006 12:09 GMT
try using these code lines :
Dim oldCI As System.Globalization.CultureInfo = System.Threading.Thread.CurrentThread.CurrentCulture
System.Threading.Thread.CurrentThread.CurrentCulture = New System.Globalization.CultureInfo("en-US")
'Your Code
WB.Worksheets(1).Range("b4") = "AAA"
System.Threading.Thread.CurrentThread.CurrentCulture = oldCI
tomerk@aman.co.il - 16 May 2006 12:10 GMT
try using these code lines :
Dim oldCI As System.Globalization.CultureInfo = System.Threading.Thread.CurrentThread.CurrentCulture
System.Threading.Thread.CurrentThread.CurrentCulture = New System.Globalization.CultureInfo("en-US")
'Your Code
WB.Worksheets(1).Range("b4") = "AAA"
System.Threading.Thread.CurrentThread.CurrentCulture = oldCI
tomerk@aman.co.il - 16 May 2006 12:11 GMT
try using these code lines :
Dim oldCI As System.Globalization.CultureInfo = System.Threading.Thread.CurrentThread.CurrentCulture
System.Threading.Thread.CurrentThread.CurrentCulture = New System.Globalization.CultureInfo("en-US")
'Your Code
WB.Worksheets(1).Range("b4") = "AAA"
System.Threading.Thread.CurrentThread.CurrentCulture = oldCI