468,291 Members | 1,723 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,291 developers. It's quick & easy.

MEMBER NOT FOUND" error HRESULT : 0x80020003 (DISP_E_MEMBERNOTFOUN

Hello friends,

I am facing this problem("MEMBER NOT FOUND" error HRESULT : 0x80020003
(DISP_E_MEMBERNOTFOUND) ) in Visual Basic 2005 (i.e. VB .NET) for the fourth
statement(ObjWb = AppXls.Workbooks.Add) in the following code. I searched ,
but couldn't get relevent solution.

Imports Excel

Dim AppXls As Excel.Application
Dim ObjWb As Excel.Workbook

AppXls = CreateObject("Excel.Application")
ObjWb = AppXls.Workbooks.Add
ObjWb.Worksheets().Items("Sheet1").range("A1").val ue = "1"

ObjWb.SaveAs("C\pp\test.xls")
ObjWb.Close()
AppXls.Quit()
Could anybody plz help me? Would be appriciable.
Thanks and regards.
Dec 27 '07 #1
1 4508


"Pallvi" wrote:
Hello friends,

I am facing this problem("MEMBER NOT FOUND" error HRESULT : 0x80020003
(DISP_E_MEMBERNOTFOUND) ) in Visual Basic 2005 (i.e. VB .NET) for the fourth
statement(ObjWb = AppXls.Workbooks.Add) in the following code. I searched ,
but couldn't get relevent solution.

Imports Excel

Dim AppXls As Excel.Application
Dim ObjWb As Excel.Workbook

AppXls = CreateObject("Excel.Application")
ObjWb = AppXls.Workbooks.Add
All the examples I have found show:
ObjWb = AppXls.Workbooks.Add(true)
ObjWb.Worksheets().Items("Sheet1").range("A1").val ue = "1"

ObjWb.SaveAs("C\pp\test.xls")
ObjWb.Close()
AppXls.Quit()
Could anybody plz help me? Would be appriciable.
Thanks and regards.
Dec 27 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by e-lores | last post: by
reply views Thread by Mark | last post: by
2 posts views Thread by andy | last post: by
2 posts views Thread by adrix7 | last post: by
3 posts views Thread by =?Utf-8?B?Sm9uIEU=?= | last post: by
reply views Thread by NPC403 | last post: by
2 posts views Thread by MrBee | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.