I am looking for code to check if a proposed save path (as string) is OK. However both the functions I have found so far - DO. NOT. WORK!
I found this code on the net http://www.jpsoftwaretech.com/excel-...ate-filenames/
But it always returns False whenever I test it. The web page states: "I've modified the original code ever so slightly; the asterisks just inside the quotation marks in Ross' code are unnecessary, if the Visual Basic Help System is to be believed." I tried adding asterisks between the symbols but that only gives me a syntax error.Please Login or Register to view this content.
So I searched again and found this:
But this is no good because it doesn't check for all the invalid symbols (full list located here: http://msdn.microsoft.com/en-us/library/aa365247.aspx)Please Login or Register to view this content.
So I tried modifying the above code (see my attempt below) but I end up with Syntax error again!
Please Login or Register to view this content.
Can anyone please provide a working function for what I am seeking and/or please let me know what is wrong with the above two functions?
Bookmarks