Folder creation

How to create folder in chosen localization with VBA? For one project I had to create folder. Had to search internet and as always helpful was site stackoverflow.com.

Quite interesting thing might be Chr(34). It allowed to use double-quotes in text message in Msgbox or Debug.Print.

Folder creation in chosen localization with VBA:

Sub FolderCreation()
' Folder creation

' Source:
' https://stackoverflow.com/questions/10803834/is-there-a-way-to-create-a-folder-and-sub-folders-in-excel-vba

Dim fso As Object
Dim fldrname As String
Dim fldrpath As String
Dim sItem As String

sItem = ThisWorkbook.Path 'path might be chosen via Folder Picker by user

Set fso = CreateObject("scripting.filesystemobject")
fldrname = "VBA_Folder"
fldrpath = sItem & "\" & fldrname
If Not fso.folderexists(fldrpath) Then
    fso.createfolder (fldrpath)
    Debug.Print "Folder " & Chr(34) & fldrname & Chr(34) & " has been created in localization " & Chr(34) & sItem & Chr(34) & "."
Else
    Debug.Print "Folder " & Chr(34) & fldrname & Chr(34) & " already existed in localization " & Chr(34) & sItem & Chr(34) & "."
End If

End Sub

95 thoughts on “Folder creation

  1. Pingback: social signals for seo

  2. Pingback: glo carts flavors

  3. Pingback: nữ kim ngưu và nam song tử

  4. Pingback: DevOps

  5. Pingback: con số may mắn của 12 cung hoàng đạo

  6. Pingback: nên đặt cây gì trên bàn làm việc

  7. Pingback: mơ thấy bị đòi nợ đánh con gì

  8. Pingback: mơ thấy xương người

  9. Pingback: mơ thấy quả mít chín đánh đề con gì

  10. Pingback: thien binh hop voi chom sao nao

  11. Pingback: đàn ông song ngư

  12. Pingback: giải mã ác mộng

  13. Pingback: nằm mơ thấy đi chùa

  14. Pingback: cách nhớ bài catte

  15. Pingback: Bildemontering Göteborg

  16. Pingback: choi game danh bai doi thuong tren may tinh

  17. Pingback: rhythm game cheat providers

  18. Pingback: move out cleaning services south bend

  19. Pingback: mơ thấy quả bưởi đánh con gì

  20. Pingback: mơ thấy thức ăn

  21. Pingback: chiem bao thay di chua

  22. Pingback: nằm mơ rụng tóc

  23. Pingback: mơ bốc mộ đánh con gì

  24. Pingback: mơ thấy chụp ảnh

  25. Pingback: Vyvanse online

  26. Pingback: greatdumps cc

  27. Pingback: cc top shop

  28. Pingback: pasar qq

  29. Pingback: buy eu driving license

  30. Pingback: Game Stores

  31. Pingback: ตู้แปลภาษา

  32. Pingback: ดูอนิเมะตอนเดียวจบ

  33. Pingback: dewaqq

  34. Pingback: organic medication

  35. Pingback: mơ thấy sấm sét

  36. Pingback: mơ bắt được cá chuối

  37. Pingback: dumps and pins

  38. Pingback: bị bọ cạp cắn

  39. Pingback: trip tips & tricks

  40. Pingback: clown wig png

  41. Pingback: mơ thấy lợn đẻ

  42. Pingback: nằm mơ thấy đầu người

  43. Pingback: mơ thấy mua nhà

  44. Pingback: cvv dumps free

  45. Pingback: real estate market

  46. Pingback: knockoff tag best clone

  47. Pingback: dumps credit card for sale

  48. Pingback: số đề con rùa

  49. Pingback: ojdhqqpn

  50. Pingback: how much levitra should i take

  51. Pingback: hoe lang werkt viagra 50mg

  52. Pingback: how often do i give liquid azithromycin to cats

  53. Pingback: cialis tadalafil

  54. Pingback: viagra without prescription

  55. Pingback: viagra 25 mg

  56. Pingback: paper writing service review

  57. Pingback: how to write a research paper apa

  58. Pingback: write an essay about my first day at school

  59. Pingback: who will help me write a scholarship essay

  60. Pingback: essay about ethics in business

  61. Pingback: augmentin 625mg price

  62. Pingback: order lasix online cheap

  63. Pingback: zithromax online fast delivery

  64. Pingback: stromectol xr

  65. Pingback: ventolin tablets 4mg

  66. Pingback: doxycycline reactions

  67. Pingback: prednisolone dosage

  68. Pingback: price of clomid

  69. Pingback: 60mg priligy headaches

  70. Pingback: diflucan multiple doses

  71. Pingback: synthroid and vitamins

  72. Pingback: walmart propecia

  73. Pingback: neurontin and dementia

  74. Pingback: metformin withdrawal

  75. Pingback: paxil withdrawal help

  76. Pingback: plaquenil 200mg

  77. Pingback: buy cialis united kingdom

  78. Pingback: buy cialis shipping canada

  79. Pingback: where can i buy cialis without a prescription

  80. Pingback: how to buy online uk

  81. Pingback: buy 36 hour

  82. Pingback: overnight retina

  83. Pingback: contact Tinder customer support

  84. Pingback: faxless cash advance fond du lac

  85. Pingback: can you buy viagra over the counter

  86. Pingback: free online dating directory

  87. Pingback: buy online generic

  88. Pingback: cialis buy paypal

  89. Pingback: is cialis safe for heart patients

  90. Pingback: cialist the yeloow pill

  91. Pingback: can i buy ativan over the counter

  92. Pingback: free online pharmacy technician practice test

  93. Pingback: international pharmacy no prescription

  94. Pingback: awc canadian pharmacy

  95. Pingback: where can i buy original cialis

Leave a Reply

Your email address will not be published. Required fields are marked *