Debug error when saving workbook

Question

Application.Workbooks.Open(C:\Data\workbook1.xls); oWB.SaveAs(C:\Reviewed\Workbook1.xls); It hits the saveline and tells meNullReferenceException was unhandled? And nothing is null that is what has me baffled! The directory exists that I am trying to save to as well.

richard smith · Answer

I got it figured out...the null reference was not the fact that the folder wasn't there but the fact that I had not set oWB to a value yet. I modified the code to read: Application.Workbooks.Open(C:\Data\workbook1.xls); oWB = Application.ActiveWorkbook; oWB.SaveAs(C:\Reviewed\Workbook1.xls); And it now works :)