create folders

Hi, I don't know anything about vba so i need some help here. I got this code: Private Sub GemSom_Click() MkDir "C:\Users\Martin\\\\\\\TEST" & Range("b6").Value & " " & Date Dim Path As String Dim FileName As String FileName = Range("b6").Value & " " & Date ActiveWorkbook.SaveAs...

Hi there, I have code that works really well except for one thing... The is a trim command in the code I used and I would like to remove it but I keep getting out of range or syntax errors. the issue part: folder = Trim(Split(Target.TextToDisplay, " ")(1)) When it created the folder it only...

Hi there again, I am trying to stabilize a process internally and this in part, is to create specific folders (on a network drive) based on the checked box values from my User Form. Each project we do may or may not need a folder to maintain working files and instead of adding empty folders...

Hi all, I would like to create folders from a list. Each item in Col A needs to be a parent folder and Col B and Col C need to be the child folders for each. Example: Excel 2010 ABC 1FranceParisNice 2UKLondonManchester 3ItalyMilanNaples Sheet: Sheet2 I tried to copy and past code from...

Hi All, I have a report which has 4 sheets, lets call it the Master file (MF) MF has been set to manual calculation because of the amount of calculations required from the formulas within. Sheet 1-3 are reports; and Sheet 4 has a 4-column table (Tab1) which is about 2000 rows tall (headers in...

I have a macro that when run, creates a set of folders in a directory based on information in a spreadhseet. Now what I want to do is create sub-folders based on another column within the same spreadhseet. Here are exapmples of the code and the spreadhseet. Sub MakeFolders_485BPOS() Dim...

Hi, I am a new to VBA coding, and would appreciate some help. I am trying to create folders in a directory using data from one column, adding a space, then data from another column as a folder name. as an example data from column C + Space(1) + data from column E would make a folder named C...

Dear all, Thanks for your helps for always. I m new to here but i follow you threads everytime. I would like to ask a code to create .dat extended files by using excels columns. For example ; at the excel at A column ( A1:A350 ) there are names ( example ; Analysis1, Analysis2...) I would like...

Specifically what I want to do is: I want a bulk amount of links from a column I have in excel like this: http://www.ImageSite.net/core/media/media.nl?id=3730&c=ACCT103457&h=e8090dfd62c03838ac16 to download to this location on my computer: E:\Documents and Settings\User\Desktop\all images and...

Is there a way to create folders\sub folders determined by a date in a field, if they dont already exist. eg Date entered in cell B8 as dd/mm/yy but displayed as ddd dd mm yy. file to be exported as G:\Event Sheets\sheet1 name\yyyy\mm mmm\dd.mm.yy - Value B9.pdf my current code for this is...