Hi!
I'm using Excel 2003 - writing a script with VBScript to read in data
from a CSV file.
One of the fields ("Client Name") will be used as the name of a
Worksheet and all the customer's info will be in the worksheet.
The field is free text, and sometimes contains illegal characters (for
Worksheet name) - *?[]\/ - and is sometimes too long.

Replace clientName, "*", "#"
Replace clientName, "\", "|"
Replace clientName, "/", "|"
Replace clientName, "?", "!"
Replace clientName, "[", "{"
Replace clientName, "]", "}"
If Len(clientName) 30 Then
clientName = Substring(clientName, 1, 30)
End If

I don't think these rows work in VBScript...
Thanks for any help,
Mechi


On Jun 4, 3:05*pm, "Jim Cone" wrote:
VBA and VBS are not the same thing.
Which one are you referring to?
What does your "substr" method do?
What version of Excel do you use?
--
Jim Cone
Portland, Oregon *USAhttp://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

wrote in message

I've been searching for a substr method for VBScript. *Is there one?
Thanks!