WorkbookBeforeClose recursive call

[karnek]

Hello,

In my add-in I want to make same actions and depends on these actions
want to save or not the actual workbook. My problem is when I don't wan
to save the document I call "wb.close savechanges:=false", but afte
this method call WorkbookBeforeClose recursive.
I already implemented this in MS Word and it works, but in excel I hav
this problem.

Can you somebody help me, please.
Thanks in advance.

Karol Nekanovi

 

[Robert Bruce]

Hello,

In my add-in I want to make same actions and depends on these actions
I want to save or not the actual workbook. My problem is when I don't
want to save the document I call "wb.close savechanges:=false", but
after this method call WorkbookBeforeClose recursive.
I already implemented this in MS Word and it works, but in excel I
have this problem.

Application.enableevents = false

<your code to save workbook>

Application.enableevents = true


HTH

Rob