Check if file exists from same folder spreadsheet was opened

**TimmerSuds** · 08-07-2016, 11:32 AM

I have a spreadsheet that may be opened from different folders.

Is it possible to create a macro to see if a file exists in the same folder that the spreadsheet was opened from?

Thanks

**Mumps1** · 08-07-2016, 01:37 PM

Try this macro:

Sub FindFile()
    Dim MyFolder As String
    Dim MyFile As String
    MyFolder = ThisWorkbook.Path
    MyFile = Dir(MyFolder & "\" & "*.xls*")
    Do While MyFile <> ""
        If MyFile = "Book4.xlsx" Then
            MsgBox MyFile & " exists."
        End If
        MyFile = Dir
    Loop
End Sub

Replace "Book4.xlsx" with the name of the file you want to check.

**TimmerSuds** · 08-07-2016, 07:10 PM

I've been unable to get this to recognize my file (Inventory.xls) located in the directory the spreadsheet was opened from.

Thanks

**jolivanes** · 08-07-2016, 10:03 PM

Just tried it and the code works like it should.
Did you type in the name exactly as is? No extra spaces, capital letters etc

**gaixixon** · 08-07-2016, 10:12 PM

Sub Find_file()
checkfile = InputBox("Pls type the file name:")
If checkfile = "" Then Exit Sub
If Len(Dir(ThisWorkbook.Path & "\" & checkfile, vbDirectory)) > 0 Then
MsgBox "File " & checkfile & " existed"
Else
MsgBox "Nothing found."
End If
End Sub

**TimmerSuds** · 08-08-2016, 04:37 AM

I was able to get this to work:

Sub Find_file()
'checkfile = InputBox("Pls type the file name:")
checkfile = "Inventory.xls"
If checkfile = "" Then Exit Sub
If Len(Dir(ThisWorkbook.Path & "\" & checkfile, vbDirectory)) > 0 Then
MsgBox "File " & checkfile & " existed"
Else
MsgBox "Nothing found."
End If
End Sub

Thanks for your help!

Check if file exists from same folder spreadsheet was opened

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Check if file exists from same folder spreadsheet was opened

Re: Check if file exists from same folder spreadsheet was opened

Re: Check if file exists from same folder spreadsheet was opened

Re: Check if file exists from same folder spreadsheet was opened

Re: Check if file exists from same folder spreadsheet was opened

Re: Check if file exists from same folder spreadsheet was opened

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Check if folder exists, Create if Not

Check if Folder exists

Check if a mailbox folder exists

Check if folder exists, if not create it

Check if folder exists, if yes just copy sheet in to folder?

[SOLVED] How to check if a file exists in an ftp folder

how to check if folder exists

Bookmarks

Bookmarks

Posting Permissions