Invoking "cmd" from VB macro

[Sri via OfficeKB.com]

Hello all,

I want to execute following dos command in my XL VB macro.
dir C:\Project\Test_Cases /s > C:\TEMP_TEST_CASE_ROOT_XXX\files.txt

If C:\Project\Test_Cases will be in a variable FName then the following
command is perfectly working fine for me.

x = Shell("cmd.exe /c dir " & FName & " /s > C:\TEMP_TEST_CASE_ROOT_XXX\files.
txt", vbHide)

The problem comes if my FName has a space in it. For example, if FName is C:\
Project\Test Cases then the above command is not working.

How to append " symbol as prefix and suffix to my variable FName.

Any help please ???

Sri

 

[Peter T]

FName = """c:\ the path"""
or
FName = chr(34) & "c:\ the path" & chr(34)

Regards,
Peter T

 

[Sri via OfficeKB.com]

Thank you very much Peter. It works fine for me...

Sri

FName = """c:\ the path"""
or
FName = chr(34) & "c:\ the path" & chr(34)

Regards,
Peter T

Hello all,

[quoted text clipped - 17 lines]

Sri