i have main workbook extracts data other workbook sheets, closes modified workbook suppressing save option.
other_wb.close savechanges = false
however when running macro or stepping through function call in debug mode still saves file. there alternative way close without saving? there explanation behavior?
i can provide more info if needed.
savechanges undefined variable. therefore empty; empty falsy, expression savechanges = false evaluates true, call becomes other_wb.close true, saves file.
you missing colon:
other_wb.close savechanges:= false put option explicit on top of code modules never have deal kind of issues.
Comments
Post a Comment