create folder

Hello everyone, I am using a script that will save a file to a specific folder based of a couple of cells. If the folder doesn't exist, the command fails. I cannot figure out how to get it to create the folder if it isn't there. Here is what I am using now: Sub File_Save() Dim Path1...

Hello Everyone I made below code to create multiple folder based on cell value but i want that path should also picked from the cell. I have folder path in F4. so instead of folder path i want to add F4 in code. please help Sub AFolderVBA2() 'Excel VBA to make a folder. Dim i As Integer...

Hello Everyone, I have one excel. in A1 i have a folder path and in B1 i have one name called Sample and C1 i have name called example I want when i click on button folder name in B1 and C1 should be created in A1 path. and move all sample prefix excel file to sample folder and example...

Hello Everyone I have a code to make new folder in path which is working as well. Sub Button1_Click() MkDir ("\\ABC\ragga\Desktop\Testing\Consolidated File") End Sub but i want that, path should be pick from the cell. Consolidated file would be folder name i want this...

Hello, I have a macro that needs to create a folder on SharePoint, then generate and save multiple files under that folder. I've done a lot of work to get the code right for creating the folder, but with no success. I've read that you need to drop the http: from the front of the folder...

Hi Everyone, I've done some searching but am not getting anywhere with my requirements. I am hoping someone can help. I have a Power Query which identifies new members. These members need cards printed and there are two files the printer needs: the new member photo and the new member...

Hi All, I have the following macro which works fine, however I would like to expand on it if possible. I would like the macro to create a file with the date if possible, where the file is then saved. Potential issue is that I may be running the macro multiple times in a day so I imagine it...

Hello, Please suggest, where I am wrong. Sub folder() Dim sFolderName As String, set_Path As String, name As String, datpath As String Dim FromPath As String Dim FSO As Object Set fs = CreateObject("Scripting.FileSystemObject") FromPath =...

Dear Mr. Excel, After days of searching for answers to no avail, I thought I'd reach out to you. Any help will be greatly appreciated! I am trying to accomplish the following: I have a column (from Cell C54 to C105) that displays the file names (they are results of formulas). Some of them...

Hi everyone, I want to backup my workbook with below codes. First of all, codes are checking backup folder whether or not. If not the folder, being created in C:\ and then being identified. Finally, this code must saveAs active workbook. But not. Where I am making mistake I don't know. Could...

Hi! This is my first post here, so bare with me. I've done some incredibly extensive research and can't quite find what I need. I'm quite a novice when it comes to VBA and have been attempting to stumble my way through creating what I'd like to create. Either way, here goes. I have a large...

How can i make this code save new folder to "\\fileserver\Users\Public\Documents\Main Customer\New Folder Name" and create 3 subfolders "Images","Work Orders","Lead Info" Public Sub SaveOnDesktop()Dim strPath As String, strFile As String 'Build Path strPath = Environ$("HOMEPATH") &...

Hey Folks, I have been searching relentlesly for a simple code to save open active workbook as value in cell a1 in a new folder named as value in cell a1 on desktop of whomever is using workbook. P.S. Thanks for all the great tips from everyone out there