H
Horatio J. Bilge, Jr.
I am using vba to open an xl file, make changes, and then close it. To
automatically save the changes, I used:
WB.Close savechanges:=True
The problem is that a form pops up with a Workbook_BeforeClose sub (like a
splash screen). I need to close that form before the savechanges dialog.
The form is called frmEndBox, and the button to close it is cmdSubmit. I
need something like
WB.Close [frmEndBox.cmdSubmit.Value=True] savechanges:=True
Hopefully someone can help with this.
Thanks,
~ Horatio
automatically save the changes, I used:
WB.Close savechanges:=True
The problem is that a form pops up with a Workbook_BeforeClose sub (like a
splash screen). I need to close that form before the savechanges dialog.
The form is called frmEndBox, and the button to close it is cmdSubmit. I
need something like
WB.Close [frmEndBox.cmdSubmit.Value=True] savechanges:=True
Hopefully someone can help with this.
Thanks,
~ Horatio