Determine if a workbook exists

The function below can be used to determine if a workbook or another file exists:

Function FileExists(FullFileName As String) As Boolean
' returns TRUE if the file exists
    FileExists = Len(Dir(FullFileName)) > 0
End Function

Example:

If Not FileExists("C:\FolderName\SubFolder\FileName.xls") Then 
    MsgBox "The file doesn't exist!"
Else
    Workbooks.Open "C:\FolderName\SubFolder\FileName.xls"
End If

Document last updated 1999-12-20 12:51:17 Printerfriendly version

User comments:

Nisha from NZ wrote (2004-08-17 22:57:14 CET):

Great help!!!!
Good info on VBA Programming. Thank you for ur web site.

Ole P. from Norway wrote (2004-03-18 12:11:40 CET):

Re: Tickertape
It would be possible to create a tickertape-like functionality in Excel, but I can't imagine that anyone would want this as it probably will make their spreadsheets calculate slower :-)

Damian Evans from Wales wrote (2004-03-17 16:47:50 CET):

for Ole
Hi ole,

always read your page iwth interest, got many useful tips on it, keep it up....

one question, is it possible to put a ticker tape type of message in Excel. By this I mean a message that continually scrolls across the screen (an example would be the Marquee screen saver).

Cheers

Ole P. from Norway wrote (2003-09-15 12:29:50 CET):

Re: looking good
Thanks Stephen!
My spoilt "royal pets" are doing just fine... :-)

Stephen Moras from Sharjah, UAE wrote (2003-09-15 09:57:15 CET):

looking good ole! :-)
Hi Ole...

Your site keeps getting better n better..Hows the royal pets doing..
Cheers

Israel from Mexico wrote (2003-09-04 02:46:37 CET):

Thanks
this is the best page.
My name is Israel I'm from mexico thanks for your page