I have a workbook (with two macro) that read input file and then run its macro on the first macro produce workbook and left it open, the second macro it run an create 3 more report in a c:\path\data directory
I would like to know how I can close my workbooks without answering YES or NO
It is always asking to close my open data file??
I have tried using Activeworkbook.close or even
ThisWorkbook.Close SaveChanges:= False
What do I need to close all my worksheet and workbook automatically without answering yes or no