Forum Discussion

shaifful's avatar
shaifful
Copper Contributor
Aug 23, 2021
Solved

Need help to replace certain string like "/" in the cell to underscore during save as pdf

Hi everyone,  I'm not very good at excel VBA and hoping you guys can help me to replace certain characters like "/" to "_" if the character exists in the cell that I wanted to print, like in the cod...
Macros and VBA
  • HansVogelaar's avatar
    HansVogelaar
    Aug 24, 2021

    shaifful 

    Change

    strName = wsA.Range("f10").Value _
          & " - " & wsA.Range("d3").Value

    to

    strName = Replace(wsA.Range("f10").Value _
          & " - " & wsA.Range("d3").Value, "/", "_")
HansVogelaar's avatar
HansVogelaar
MVP
Aug 24, 2021

shaifful 

Change

strName = wsA.Range("f10").Value _
          & " - " & wsA.Range("d3").Value

to

strName = Replace(wsA.Range("f10").Value _
          & " - " & wsA.Range("d3").Value, "/", "_")
shaifful's avatar
shaifful
Copper Contributor
Aug 24, 2021

Thank you very much HansVogelaar , it works like charm. This really helps me and my fellow friend. Thanks again for your help. 

Resources