remove a "/" from a VBA string

[kgkev]

I have a macro that is printing to PDF.

The file name is generated from some factors on the spreadsheet however it might end up containing a "/"

After I have the variable stored as "filename" how do I change any /'s into -'s

example.

My file name might be

TSP0011 - FORD - 1234 (which works)#

but it might also be

TSP0011/1 - FORD - 1234 (which needs to change to ...
TSP0011-1 - FORD - 1234

Thanks

 

[GTO]

Try:

Sub exa2()
Dim strFName As String
    
    strFName = "TSP0011/1 - FORD - 1234"
    MsgBox ">" & Replace(strFName, "/", "-") & "<"
End Sub

 

[JamesW]

Hi,

Try:

    fName = "TSP0011/1 - FORD - 1234"
    fName = Replace$(fName, Mid$("/", 1, 1), "-")

Change names of variables (or wherever the string is stored).