How to check if the file is already open

[ThrottleWorks]

Hi,

I am trying to open 15 different excel files. I need to check if the file is already open.
I tried 2-3 different codes available on Google but somehow the open file is not getting detected by code. Can anyone please help me in this.

https://support.microsoft.com/en-us/kb/291295

http://stackoverflow.com/questions/9373082/detect-whether-excel-workbook-is-already-open

http://stackoverflow.com/questions/9373082/detect-whether-excel-workbook-is-already-open

 

[Hui]

The code in the first link works fine in Excel 2010, 2013 and 2016

What version of Excel are you using ?

Can you attach your macro's

 

[Marc L]

Hi !

Before to search anywhere, better is to see samples from Chandoo !
​

 

[ThrottleWorks]

Hi @Hui sir, thanks a lot for the help. I am using Excel 2010. Will try to upload my code shortly. Have a nice day ahead.

Hi @Marc L sir, thanks a lot for the help. Have a nice day ahead.

 

[Deepak]

Hi ThrottleWorks

I like your friendly nature as same is not common at all with the users.

But, I feel that you often skip to uplaod/share workbook/code in very first post ,which later failed to accomplished the the goal by the visitors.

It's a nice gesture to first arrange the required materials before building any shape irrespective of look for items after starting of the task.

 

[ThrottleWorks]

Good afternoon @Deepak sir, thanks a lot.

I am aware that I must upload sample data with my question I am really embarrassed for not doing so.

Going forward I will try to upload sample details in the first post itself.
Have a nice day ahead.