Excel VBA - Identification of illegal characters in filenames

[magd0095]

I am running a macro in Excel which creates a large number of files wit
filenames taken from cells on a spreadsheet. The filenames correspon
to project names and currently contain characters which cannot be use
in a filename (e.g. "/" or "#").

Is anyone aware of any code which will identify any filenames whic
will not be accepted and strip out the offending character(s)?

Thanks
Mar

 

[Bernie Deitrick]

Mark,

Chip Pearson has posted code like this:

Dim Ndx As Integer
Dim FName As String
Const BadChars = "/$:\'<|>*" ' put your illegal characters here

FName = Range("A1").Text
For Ndx = 1 To Len(BadChars)
FName = Replace$(FName, Mid$(BadChars, Ndx, 1), "_")
Next Ndx

You can modify to include in your code.

HTH,
Bernie
MS Excel MVP