remove space from File name 1

[vickspills]

I have a vb script and its failing because of a space in file name(abc xy.xlsx). I tried opeion ch(43) and """" options but not working.
Can somebody help me with this ?

 

[strongm]

Failing/not working how?

 

[hackoo]

You can add double quote to the filename with this function :

FileNameWithSpace = "abc xy.xlsx"
wscript.echo DblQuote(FileNameWithSpace)
'--------------------------------------
Function DblQuote(Str)
    DblQuote = Chr(34) & Str & Chr(34)
End Function
'--------------------------------------

 

[mrmovie]

never dreamed of a DblQuote Function, like it, it would have saved me years of typing Chr(34)'s ;-)

I Hear, I Forget
I See, I Remember
I Do, I Understand

Ronald McDonald