excel vba - VBA Workbook Savechanges = False still saving and closing workbook when running Macro -


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