Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Valid File Path Format
Good morning
How do you check a value to see if it is in a valid file path format? Thank you Todd Huttenstine |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Valid File Path Format
Todd,
I don't think there is a (built in) way to check just the syntax of a file name. Since, I assume, you are going to use the value to open or save a file, just go ahead and do the operation and use an error trap to determine the success of the operation. An alternative would be to use the Dir() function, and test for an error. Dim FNum As Integer Dim FName As String On Error GoTo ErrH: FName = "invalid/::???file\\\??name" FNum = FreeFile() If Dir(FName) = "" Then ' do nothing End If Exit Sub ErrH: If Err.Number = 52 Then MsgBox "Invalid filename " End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Todd Huttenstine" wrote in message ... Good morning How do you check a value to see if it is in a valid file path format? Thank you Todd Huttenstine |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Valid File Path Format
"Todd Huttenstine" schrieb im Newsbeitrag ... Good morning How do you check a value to see if it is in a valid file path format? Thank you Todd Huttenstine Hi Todd, no "out of the box" solution, but you should pay attention to the following points: - Path length is limited to 254 chars on Windows systems AFAIK - Some characters are not allowed (?, *, etc.) so check your string for occurences of these chars, e.g. with Instr(...) - Does valid also mean that the path exists? If so, the following function might be useful: rivate Function PathExists(pname) As Boolean ' Returns TRUE if the path exists Dim x As String On Error Resume Next x = GetAttr(pname) And 0 If Err = 0 Then PathExists = True _ Else PathExists = False End Function (taken from: http://www.j-walk.com/ss/excel/tips/tip54.htm) Another useful link is: http://www.primeconsulting.com/faqs/faq2000.html HTH, cheers, Stephan |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Valid File Path Format
Thanks didnt think about doing that. It works. I looked
in VBA help and could not find a list of all the error numbers. Do you have a list that lists all the possible err types? Todd -----Original Message----- Todd, I don't think there is a (built in) way to check just the syntax of a file name. Since, I assume, you are going to use the value to open or save a file, just go ahead and do the operation and use an error trap to determine the success of the operation. An alternative would be to use the Dir() function, and test for an error. Dim FNum As Integer Dim FName As String On Error GoTo ErrH: FName = "invalid/::???file\\\??name" FNum = FreeFile() If Dir(FName) = "" Then ' do nothing End If Exit Sub ErrH: If Err.Number = 52 Then MsgBox "Invalid filename " End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Todd Huttenstine" wrote in message ... Good morning How do you check a value to see if it is in a valid file path format? Thank you Todd Huttenstine . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
file format or file extension is not valid...error message | Excel Discussion (Misc queries) | |||
File format not valid | Excel Discussion (Misc queries) | |||
File format is not valid | Excel Discussion (Misc queries) | |||
file format not valid | Excel Discussion (Misc queries) | |||
file format not valid | Excel Discussion (Misc queries) |