Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 55
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 55
Default 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



.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to use the "shell" command? Tom Excel Discussion (Misc queries) 11 April 27th 10 12:52 AM
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
change "true" and "false" to "availble" and "out of stock" inthestands Excel Worksheet Functions 2 July 19th 07 07:05 PM
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next BCB New Users to Excel 7 May 13th 06 10:02 PM
Problem using Excel's "Shell" command Jim Simpson Excel Programming 0 May 20th 04 06:28 PM


All times are GMT +1. The time now is 01:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"