Major problem with same workbook name

[Eisasuarez]

Hi All

I am trying to open up a workbook from my existing file (that file is the latest workbook) but im having 2 problem

1) I want to disable any workbook open code for the new workbook so if opened by macro then disable but if that workbook
is opened physically then the workbook open should work as normal

2) If the new File name is exactly the same as the current filename i run into a problem as its showing as the workbook with the same file is already opened

I need to disable this message and open up that new workbook

what is the best code to achieve this without any error messages please

Than You

 

[Eisasuarez]

The filename im opening could be the same as the filename of the workbook that is opened