Getting error in using a textbox1.value in Shell

[mrmohit1a]

I am getting an error when i make changes to this code:
Shell "cmd.exe /c D:" & " && dir /s G:\123\12414.ps > txt.xls"
to this:
Shell "cmd.exe /c D:" & " && dir /s G:\123\" & textbox1.Value & ".ps" > txt.xls
i am just using textbox1 value from a variable
Please help me
Thanks in advance

 

[NARAYANK991]

Hi ,

If we accept that the first command line text is correct , should the second not be as follows :

Shell "cmd.exe /c D:" & " && dir /s G:\123\" & textbox1.Value & ".ps > txt.xls"

where the ending double quote has been shifted to match its position in the first version.

Narayan

 

[mrmohit1a]

Bro thanks a lot you saved my time.