On Jun 5, 5:31*pm, "Jim Cone" wrote:
If you are using the Visual Basic Editor and not
the Microsoft Script Editor then try...

*clientName = Replace(clientName, "*", "#")
*clientName = Replace(clientName, "\", "|")
*clientName = Replace(clientName, "/", "|")
*clientName = Replace(clientName, "?", "!")
*clientName = Replace(clientName, "[", "{")
*clientName = Replace(clientName, "]", "}")
*clientName = Left(clientName, 30)
--
Jim Cone
Portland, Oregon *USAhttp://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


wrote in message
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 USA
http://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!- Hide quoted text -

- Show quoted text -

It worked!!!
I'm using VBSedit (free version)
Thanks!