folder creation

  1. A

    VBA Creating a New Folder if Folder Doesn't Already Exist

    Hi All, First post! :) My question is (hopefully) very simple: I need a piece of code to add a new folder if the folder doesn't already exist. I have a working code that renames folders that appear is column A to their new name in column E (I pulled from the internet). I want to simply add...
  2. S

    Track changes then call changed value in module

    Hi! I've searched everywhere (not just this forum) and I can't figure this problem out and therefore I hope someone here can assist :) What I want: I want to be able to create a folder whenever a new entry is made in i.e. column A with the folder name being whatever is entered in the row. I.e...
  3. S

    The code doesn't Run when saved in Personal.Xlsb for creating folders.

    Dear Team, I have the following codes as mentioned below which works fine when Running in Macro Enabled Work book but my Objective is to run these subroutine as mentioned below with Personal.xlsb and Saving it as Macro free workbook . The code are as follows The code creates folder and...
  4. H

    Auto Folder Creation based on given path/folder names

    Hello Team, I am looking for the below help in the creation of automation in folder create and assign the names based on the given names in cells/path. If you see column B and C and it goes on till 10 or so on ....when I run the auto program should create the main folder/subfolders...
  5. B

    check if folder exist with wildcards

    I would like to use a wildcard to check if a folder exist. i have tried the following: "C:\Users\*\Desktop\New folder" "C:\Users" & "*" & "\Desktop\New folder" "C:\Users\ + "*" + "\Desktop\New folder" i get, "bad file name or number." is there a way to do this? Sub TestForDir()Dim strDir As...
  6. B

    Create Folder in VBA

    Thanks for looking at my post. What I would like to do is have a macro in a workbook that when run it would create a folder with the same name as the excel file in the same location. Then I would like it to somehow save the excel file in the folder that was just created and delete or kill the...
  7. L

    Macro to Create New Folder using User Defiend Pathway

    I have a code that creates a new folder to a specific pathway but the issue is now we need to be able to allow the user to define the pathway (location changes weekly and by user). I can't figure out how to get it to allow me to let the user pick where to create the folder. Current Code: Sub...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top