Thread: Shell "mkdir"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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