add / in between filepath VBA

[nguyen_tri]

Hi all,
I am trying to format the filepath from: \Active\1-OperatingCompanies\abc\report\excel.xlsm to \\Active\\1-OperatingCompanies\\abc\\report\\excel.xlsm. Do you guys know how I can do this in VBA? Thank you.

 

[Rick Rothstein]

Hi all,
I am trying to format the filepath from: \Active\1-OperatingCompanies\abc\report\excel.xlsm to \\Active\\1-OperatingCompanies\\abc\\report\\excel.xlsm. Do you guys know how I can do this in VBA? Thank you.

IF..

Filepath = "\Active\1-OperatingCompanies\abc\report\excel.xlsm"

then follow that with this...

Filepath = Replace(Filepath, "\", "\\")

and Filepath will then contain the text you want.

 

[nguyen_tri]

Thank you so much. This is very helpful.