Filename checking before open

[Villalobos]

Hello,

I would like to ask regarding the file naming.
Is it possible if I would like that the code check name of file before the opening and if it is doesn't match with the pre-definied name then the file stay in closed?

Thanks in advance the response!

 

[Deepak]

Ya! Share the sample.
Which type of file & where it's located.

 

[Villalobos]

Hi,

I have uploaded an empty sample file.
How do you mean "Which type of file & where it's located."? If for this then... the type of file is .xlsm, the location should not to matter just the name.

 

[Deepak]

Ha ha ha!!
What the file you have uploaded ???
You must to be awarded for the same.

However try the below code in "Thisworkbook" & must create the backup of the file before you try.

Option Explicit
Private Sub Workbook_Open()
Dim file As String
file = "C:\BAC\GGG\DDE\New\xyz.xlsm"  ' Must change before try
If Dir(file) = "" Then ThisWorkbook.Close False
End Sub

 

[Villalobos]

ops... too late for me...

however your advice was perfect

Thank you Deepak!

 

[Deepak]

Welcome!!!!!