VB.Net, Obj Ref not set to an instance of an Obj

Obj Ref not set to an instance of an Obj

Author	Message
Jason Moor #1 / 2	Obj Ref not set to an instance of an Obj I have a problem saving an excel workbook using win 2k and office 2k through VB.Net. The following code works fine using win xp and office xp. xlWkBk = xlApp.Workbooks.Add xlWkBk.SaveAs() The following gives the same error xlWkBk = xlApp.Workbooks.Add xlWkBk.SaveAs(strPath) 'strPath is a valid Path and file 'name. I get an error that says Object refrence is not set to an instance of an Object. Does anyone know what is causing this? I can add/remove sheets to/from xlWkBk and modify them with no problem.
Wed, 09 Nov 2005 00:57:15 GMT

Vincent Wiege #2 / 2	Obj Ref not set to an instance of an Obj Jason, See if this works. --- xlWkBk.ActiveWorkbook.SaveAs(strPath) xlWkBk.ActiveWorkbook.Saved = True --- Vince Quote: > I have a problem saving an excel workbook using win 2k > and office 2k through VB.Net. The following code works > fine using win xp and office xp. > xlWkBk = xlApp.Workbooks.Add > xlWkBk.SaveAs() > The following gives the same error > xlWkBk = xlApp.Workbooks.Add > xlWkBk.SaveAs(strPath) 'strPath is a valid Path and file > 'name. > I get an error that says Object refrence is not set to an > instance of an Object. Does anyone know what is causing > this? I can add/remove sheets to/from xlWkBk and modify > them with no problem.
Wed, 09 Nov 2005 01:19:27 GMT

Page 1 of 1

[ 2 post ]