ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How can I create five folders after this with a spacific name (https://www.excelbanter.com/excel-programming/419903-how-can-i-create-five-folders-after-spacific-name.html)

David Shoemaker

How can I create five folders after this with a spacific name
 
MkDir "C:\" & Range("C3").Value

Example: C:\12345\ART, LG1, G-CODE, LG3, LR2

Bernard Liengme

How can I create five folders after this with a spacific name
 
Sub tryme()
For Each mycell In Range("C3:C6")
MkDir "C:\" & mycell.Value
Next
End Sub

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"David Shoemaker" wrote in
message ...
MkDir "C:\" & Range("C3").Value

Example: C:\12345\ART, LG1, G-CODE, LG3, LR2





All times are GMT +1. The time now is 03:32 PM.

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