Outlook VBA - Mail to Excel

Hi,

I need some help for the below outlook VBA code. The code is working perfectly, but before I run this code, I need to close all the excel files that are open. If I didn't close all the opened excel files, I am getting a message that Log.xlsm is already open and code closes all the opened excel files.

Is there any tweak or code to open the Log.xlsm file in background without closing other opened excel files?

Please Login or Register  to view this content.

All your help will be much appreciated.

Thank You.

You'll have to add an on error routine to do the check for you.
A User Defined function that returns a true or false then take the necessary steps

@pradeepdeepu_001: did you manage to work it out?
@ggkrish2004: If you want answers I suggest you ask your own questions in your own post, you can at least make an effort and explain what you want your question is very unexplicit!