ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Shell "mkdir" (https://www.excelbanter.com/excel-programming/305940-shell-mkdir.html)

Robin Clay[_3_]

Shell "mkdir"
 
Greetings !

My code generates a value for

TargetDir = [say] "C:\myDir"

the line of code that reads -

Shell "mkdir " & TargetDir

generates a run-time error 53 "File not found"


How can I overcome this ?



RClay AT haswell DOT com

Ron de Bruin

Shell "mkdir"
 
Hi

Sub test()
Dim TargetDir As String
TargetDir = "C:\myDir"
MkDir TargetDir
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Robin Clay" wrote in message ...
Greetings !

My code generates a value for

TargetDir = [say] "C:\myDir"

the line of code that reads -

Shell "mkdir " & TargetDir

generates a run-time error 53 "File not found"


How can I overcome this ?



RClay AT haswell DOT com




Robin Clay[_3_]

Shell "mkdir"
 

SO simple - when you know how ! Thank you.

-----Original Message-----
Hi

Sub test()
Dim TargetDir As String
TargetDir = "C:\myDir"
MkDir TargetDir
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Robin Clay" wrote

in message ...
Greetings !

My code generates a value for

TargetDir = [say] "C:\myDir"

the line of code that reads -

Shell "mkdir " & TargetDir

generates a run-time error 53 "File not found"


How can I overcome this ?



RClay AT haswell DOT com



.



All times are GMT +1. The time now is 08:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com