Is string allowable as a file name
Hello
I am writing a version control macro and need it to identify whether the file name entered by the user is valid as a file name. Can anybody either: a) provide some code that identifies whether a given text string is allowable as a file name? b) provide a list of all characters that are not allowable in file names so that I can write such a piece of code myself. Thanks John |
Is string allowable as a file name
Google is your friend:
http://msdn2.microsoft.com/en-us/library/aa365247.aspx In addition to the rules here, you'll find that for use in Excel, it is also helpful to disallow [square brackets] and 'single quotes' from file names. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "JT" wrote in message ... Hello I am writing a version control macro and need it to identify whether the file name entered by the user is valid as a file name. Can anybody either: a) provide some code that identifies whether a given text string is allowable as a file name? b) provide a list of all characters that are not allowable in file names so that I can write such a piece of code myself. Thanks John |
Is string allowable as a file name
And tildes "~" as I've recently discovered.
"Jon Peltier" wrote: Google is your friend: http://msdn2.microsoft.com/en-us/library/aa365247.aspx In addition to the rules here, you'll find that for use in Excel, it is also helpful to disallow [square brackets] and 'single quotes' from file names. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "JT" wrote in message ... Hello I am writing a version control macro and need it to identify whether the file name entered by the user is valid as a file name. Can anybody either: a) provide some code that identifies whether a given text string is allowable as a file name? b) provide a list of all characters that are not allowable in file names so that I can write such a piece of code myself. Thanks John |
All times are GMT +1. The time now is 06:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com