Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is filepath valid?
You need a function. Open VB editor (ALT + F11) insert a new module and paste
this code in: Public Function Filethere(strFullPath As String) As Boolean If Not Dir(strFullPath, vbDirectory) = vbNullString Then Filethere = True End Function in b1 next to your filepath in a1 type =filethere(a1) drag down as required. It will return true if the path is valid or false. Will that do? Mike "Rookie_User" wrote: I have a column that contains a file path with the file at the end - all contained in the cell. There are about 150 rows. I would like to put something in column be that says - yes the path and file are truly there or No it is invalid. I have searched multiple places and have not found anything pointing to how to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create filepath if it's not available | Excel Programming | |||
Filepath | Excel Discussion (Misc queries) | |||
Filepath | Excel Discussion (Misc queries) | |||
get filename and filepath | Excel Programming | |||
Selecting File and FilePath | Excel Programming |