Is there a function to check/enforce that a string is a valid Windows filename?
I am generating an Excel spreadsheet via OLE automation and the filename is based upon the customer name as entered in the database by the user. Unfortunately the users sometimes enter characters such as a \ (backslash) or / (slash) that is not valid in a Windows filename. Before I go trying to write a clever function to strip these characters out I wondered if there was one already I could use or maybe even get Format() to do it???
Regards
Darren
Start Free Trial
