VBA check if a new workbook is created

[Wicked_]

Hi.

Got a question.
Is there a way to create a VBA code, that constantly checks a specific folder, if a new workbook is created?
For it to be easy to understand, lets pretende workbook1 is called 1.xlsm (which im using), then if i create a book called 2.xlsm inside that same folder, i want to code to recognize it, and launch a specific userform inside book 1.

Is this possible ?

Thanks.

 

[Wicked_]

Not sure, I used this as a test.

Sub Testfile()
If FileExists("C:\Temp\TestBook2.txt") Then
    MsgBox "Found"
Else
    MsgBox "Nope"
End If
End Sub

Testet the same.
Got Nope when i had the correct name, and found when it when i had a wrong name (the name of the file itself)

 

[nemmi69]

Hmmm not sure whats going on.

 

[Wicked_]

Hmmm not sure whats going on.

Found a solution.

added Not.

If Not CFF_Found = FileExists

Then it worked :P

Thank you very much for all the help you provided!

 

[nemmi69]

Ah, I stopped using the CFF_Found and just used FileExists("C:\Temp\TestBook2.txt") which answers true if found