Greetings of the day to all,
I am using Excel 2007 with a VBA project (Windows XP SP2). I am closing my workbook after a certain event by code like this: -
"workbooks("workbook name").close savechange:=true"
My project constitutes of three workbook and I am closing them one by one with the same code, at the end I am getting error more frequently "Excel has encountered a problem and needs to close. Sorry for the inconvenience.".
This error is bugging me alot.
Members please help out.