How to disable "Do you want to save the changes to <file name>" manual prompt every time while closing excel files having macros (macro password not known), while in automated task mode which is closing and opening files automatically. Thanks
How to disable "Do you want to save the changes to <file name>" manual prompt every time while closing excel files having macros (macro password not known), while in automated task mode which is closing and opening files automatically. Thanks
If I want to close another workbook in VBA, I would use something like: workbooks("otherworkbook.xls").close savechanges:=false (false means I want to discard those changes.)
My problem is I have approx. 6000 excel files and these files go as input to a software program which automatically picks data from these files by opening and closing them on its own. But since these files contain macros so every time a self opened file is closing down and then it asks for a manual intervention to save changes or not, which defies the whole purpose of automation. I am a very basic user of excel and so would like to know how can I stop that prompt so that the whole process runs smoothly.
Bookmarks