Loading

Debug error when saving workbook

richard smith

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.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

richard smith13y ago
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 :)