Closing Excel 2013 after sending email

[wrybel]

Hi Excel Experts,

I have a macro which update a pivot table and if there is a change in pivot table send an e-mail if not saved and closed workbook (the workbook is open automatically by windows scheduler).
The problem concern closing whole Excel 2013 window.
If there is no change in PT my workbook does not close and I see a grey window of excel and when there is a change after update and sending email, I see my pivot table in open workbook.

How sould I modified a code to closed workbook no meter if there is a change or no in PT.

http://www.excelforum.pl/topics3/jez...je-vt47475.htm

Thanks for help !

Please Login or Register  to view this content.

[jonesa01]

Hello,

The grey window will appear when the worksheet is closed and the application is left open.

If you just want to close the window make sure the window to be closed is active and then close the active window:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

to save changes. This should close that particular window an leave other excel windows running.

Hope this helps?

Thanks,

Adam