File Exists on Disk
Function DiskFileExists(sFilePathAndName As String) As Boolean
‘Returns True if the file exists, False if it doesn’t
DiskFileExists = CBool(Len(Dir(sFilePathAndName)))
End Function
Daily posts of Excel tips…and other stuff
Function DiskFileExists(sFilePathAndName As String) As Boolean
‘Returns True if the file exists, False if it doesn’t
DiskFileExists = CBool(Len(Dir(sFilePathAndName)))
End Function
Certain comments are subject to moderation and may not appear immediately. You can use HTML tags in your comment. If you include a greater-than or less-than sign or anything else that could be interpreted as HTML, your comment won't look nice. You need to escape those characters. To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].
SAMAD:
VERY NICE AND QUICK FUNCTION
30 November 2004, 7:35 amTHANKS
coffee joe:
Very Elegant!
15 June 2005, 11:11 pm