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