VBA To Create A New Folder From A Textbox Value
I don't know if anyone has tried this but it possible using vba to create a new folder in a directory from the text of a textbox?
I have made a userform that I use to collect a persons first name & surname.
I then created a folder in a directory manually (e.g Z:spnzphotos)
I then scan their photo and place it into the folder.
Is it at all possible to have a piece of code that once I press a command button is creates folder ready for me to add the photo to?
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
VBA - Create Folder With Date In Name, Populate With Sheets
I have a workbook that will have many modules (5) that will perform all sort of checks etc. The output for each module is a worksheet that i need to export to a new workbook named with the name of the original sheet and current date appended e.g. "Dbase 27 06 2008.xls". Every time any of the 5 modules is run a check is performed whether a folder with a specific name and date exists e.g. "Audit Tool 27 06 2008" and if it does not exist yet to create it. The new workbook should be saved to this folder with above mentioned name e.g. "Dbase 27 06 2008". I found some info on this topic but I just cannot assemble all pieces of code together (I am new to this).
View Replies!
View Related
Create A New Folder From A Cell Value
I am wondering if it is possible to get excel to Create a new folder from a cell value? I am entring data into cells Eg A1-F1, and then the next line of data is in A2-F2 and so on. What I'd like is when I enter data (the date) in the F column then it will create a folder with the value of H2 (=A2&B2&D2&E2)
View Replies!
View Related
Create Hyperlink To Folder
I'm trying to create a link to a folder and to insert it in a cell. The folder name is: "C:DISCO CTEMPLATES #1". I tried to copy that text and paste it into the cell. Excel recognizes that as a hyperlink but when I click the cell a message appears: "Cannot open the selected file" Could the problem be because of the "#" symbol?
View Replies!
View Related
Create A Windows Folder On A Server
I would like a windows folder to be created on a server from cell Cbut to be filtered by the Data in B. dwights folder on teh server to create '124 elm street' from the in C1 james folder to the server to create the folder '15 killfops' street'from C5 \server empdwight \server empjames .....
View Replies!
View Related
Code To Check For And Create New Folder
I have a macro that creates a spreadsheet on a weekly basis and have been using it for quite sometime. Due to the large number of spreadsheets I would like to incorporate some code that would create a folder every month. I would assume that the code would need to include a check routine to see if a folder for that month exsists.
View Replies!
View Related
Macro To Create New Folder And Save File
I want to create a macro that will create a new folder called "Fungicide Quotes" under my documents and will save the workbook using the cell reference d4:f4 for the file name, which are merged cells. I have tried the following but can't get it to work. Any help would be appreciated, Thanks Sub Save_wrkbk() Dim strFilename, strDirname, strPathname, strDefpath As String On Error Resume Next strDirname = "Fungicide Quotes" strFilename = Range("d4:f4").Value strDefpath = "C:My Documents" If IsEmpty(Filename) Then Exit Sub MkDir strDefpath & strDirname strPathname = strDefpath & strDirname & "" & strFilename.......................
View Replies!
View Related
Create Folder.... Make Directory MkDir
how can I creat a directory and then save the same file into that directory. At the moment Im using - ThisFile = Range("T3").Value ActiveWorkbook.SaveAs FileName:=ThisFile ...which works great, but before I do this, I want to create a folder with the name the name/value in T4, then ofcourse save the file into that folder ....
View Replies!
View Related
Create Automatic Link To Files In Same Folder
I have two files, 1. Form Templete & 2. Student Data Index. (Both files will be placed in same folder) About Form Templete : This is a simple form, containing some fields. Fields which i require are Form No., Student's name & Standard. About Student Data Index : This file is to maintain records. Each time when I fill form for a new student i will copy paste the form templete file & rename it by form no. (Entered in the Form Templete file, Form No. field) My question is : Is it possible that whenever i create a new file in the same folder with student's name the required fields in the Student data Index get filled automatically, apart from that the new file created get hyperlinked & when i click on form no. the form for that student gets open?
View Replies!
View Related
Save Date As Text And Create Folder
In Cell N1 i have 02/02/09 but i have formatted it to look like Feb Invoices 2009. In the strpath below it saves the file to a folder In desktop/"Cell N1" But it tries to save it as c:Documents and SettingsDaveDesktop229 I would like it to save as c:Documents and SettingsDaveDesktopFeb Invoices 2009. Also if the folder does not exist the macro fails. How can change this macro to 1. Change the folder from 020209 to Feb Invoices 2009 2. If folder does not exist then create it.
View Replies!
View Related
Create A Folder Structure Before Dumping A CSV Export
I am trying to create a folder structure before dumping a CSV export frm the Excel. I am trying to use MkDir but it gives me a run time error 76. I am testig the code in my PC. Pleaselet em know if I have to change any configuration in excel file. Also, is there a way to call the windows system command and create the folder structure?
View Replies!
View Related
Create Folder & Export Sheet, Not Working
I was working on some code that would create a new folder in My Documents and within that folder export the current worksheet and save it there with a particular name. After doing so I need it to return to the original worksheet and clear contents. I would also need to export to the new sheet only contents of the cells without any macros or buttons.
View Replies!
View Related
BeforeSave, Create Folder & Sub-foldername If Has Not Been Created
Example below is in my macro and when my peer is running this worksheet which has Workbook_Open() enabled in "ThisWorkbook", the outcome is that he can not successfully save this workbook because he doesn't have the folder and sub directory in his C: drive. How do I code it such that in the event the user does not have the specified folder and sub-foldername, it will automatically create one for him and save it as "C:Spare PartsCritical ListStocking Status.xls". Application.DisplayAlerts = False ActiveWorkbook.SaveAs Filename:= _ "C:Spare PartsCritical ListStocking Status.xls"
View Replies!
View Related
Unprotect ALL Sheets, Create Folder And Save Copy On Desktop
I have a workbook which consists of 28 worksheets, all of which are protected, and are running on a code which automatically keeps all sheets at "unlocked cells" in the selection field. The sheet is also password protected for write-access… I would like a Macro, or some sort of code, that when activated… it unprotects ALL sheets (which use same password), creates a folder on the users desktop, and saves a copy of the document in there… entitled "copy of {filename}" It must also remove the "write access" password…
View Replies!
View Related
Create A Editable Textbox
I want to create a editable textbox in a UserForm like a MS WORD that the user can edit the text (font, color, size, align...). This text will be show in a label or textbox in other UserForm in a programmable time if no user interference. this programmable time is already soon.
View Replies!
View Related
Dynamically Create Textbox
I'm looking for some VB code that will enable me to dynamically create Textboxes for every value that I have in a range. Example date in range B2:B5: apple banana orange pear I would want the macro to create 4 Textboxes on the active worksheet, each one with the text contained in the range.
View Replies!
View Related
Create Hyperlink In Userform Textbox
sometimes i'll have some text i want to show in a userform textbox. let's say the text happens to be in a sheet named story, and it is in A1 of the worksheet. A1 says, for example: " The next big thing can be found by clicking here " if the note above were on a web page, all you'd have to do is click on 'here' and you are off the the next big thing. but so far, when i use this code to bring the text in story!A1 into the userform textbox all i get is the text. there is no 'clickability' as it were. Me.textbox.Value = Range("story!A1").Value is there some bit of code magic one can use to make a userform textbox function with html code?
View Replies!
View Related
Create Basic UserForm. TextBox, Buttons...
I want to do is have a User form that allows a user to add a new column across several sheets (i.e. b2, then c2, then d2) where what the user has selected from 3 defined ranges (in this case commodity, pack_type and pack_spec) is concatenated. see the example attached. So for exmaple, I would like the choice of adding into cell B2 across all sheets (except sheet pack) gold solid 5kg. Then I can add the next into c2. I have tried searching few a few examples of userforms with various problems but I dont know how to code it correctly.
View Replies!
View Related
To Create A Userform With A Textbox To Enter A Product Code
i would like to create a userform with a textbox to enter a product code , a command button to run VBA and a big text box to show output of VBA from Textbox 1 which i will connect to DB and pull back information relevant to that product code , is this possible i can create the userform no problem and already have code to pull back from DB into Excel ,
View Replies!
View Related
Create UserForm TextBox At Run-Time & Auto Size To Fit Text
I have a user form on which I need to create a textbox every time the user clicks a button. There are too many to create them all in advance and make them visible when needed. The sample attached, from this forum, is good, except, the numbers in the text box just scroll along and I need to see all the text typed into my textboxes. I would like the textboxes to be multiline, wordwrap and have them resize according to the amount of text.
View Replies!
View Related
Choosing The Right Files From The Folder Through Vba
I would like to get some help on choosing the right files through vba codes. I have the dates in cell a3 and b3 and all my files ends with the date. The user inputs the date and the code should get the data within that date. I would like to get some thoughts on how to get the value of cell a3 and b3 and open only those files from the folder.
View Replies!
View Related
Choose Destination Folder With Vba
I would like a user of my program to choose the destination folder where a .txt file will be saved. I have code below which allows the chooser to browse through folders and choose a file: Dim f1 As Variant, s1 As Variant s1 = "#1: Choose the .txt file which contains montly data for the stock price." f1 = Application _ . GetOpenFilename("TextFiles(*.txt),*.txt", , s1) txt2.Text = f1 I want the user to browse folders and subfolders like they can with the above code. However the user will select a file path not a particular file. In the case of the code above, the text of Text Box txt2 would be set to the file path (i.e. "C:Documents and SettingsAdministratorDesktop")
View Replies!
View Related
Workbook Does Not Copy To Vba Created Folder
I am having trouble getting a copy of current workbook to save (with a hopefully unique name) into a vba created folder. The folder creates fine on any drive that I have access to, but the workbook never turns up. The code is only an extract from the whole but it still fails in isolation. Sub Macro1() Copyit: Dim fso Dim fol As String Dim flag As String fol = "E:Excelb4macrobackups" ' change to match the folder path Ans5 = MsgBox("Create Backup of " & ActiveWorkbook.Name & "?" & vbCrLf & vbCrLf & " Backup File Path:" & vbCrLf & vbCrLf & fol, vbYesNoCancel + vbExclamation) If Ans5 = vbNo Then Exit Sub If Ans5 = vbCancel Then MsgBox "Procedure Terminated!", vbExclamation: Exit Sub.........
View Replies!
View Related
VBA Open File In Dynamic Named Folder
Anyone up for getting me started on code to open a file in a "dynamic" directory, specifically: Where Main directory is G:REPORTS The file name is "Pivot_xx-xx-xx.xls" The directory where the file is located is G:REPORTSxx-xx-xx xx-xx-xx is yesterday's date
View Replies!
View Related
Formatting TextBox And Check Which TextBox Is The Active TextBox In The Loop
I am attempting to format some TextBoxes from within a For/Next loop. I need a way to check which TextBox is the active TextBox in the loop. Using i as the variable, I came up with this code snippet: Me.Controls("TB" & i).Text = Format("TB" & i, "mm/dd/yy") If i = 3, this gives me in TextBox3 (which is called TB3) the text 'TB3' and not the value of what is in TB3. It has got to bo something simple, I just can't see it!!!
View Replies!
View Related
Using VBA To Create VBA Code On The Fly
I have a vba module that reads a value from a txt file and saves that value in a variable called "iniInfo". I want to permanently assign that value programatically by using VBA code to create a Public variable e.g. "PUBLIC CONST conFIg = iniInfo" in my modGlobalVar Module. (Of course, this would only create the code if the "conFig" variable doesn't already exist.)
View Replies!
View Related
Refer Folder/Filename In VBA Code Through Named Cell Reference
I have the following codes in which I am to refer a file and folder to do some further processes. myfilename = "C:Documents and settingsacsMy DocumentsEntrymyfile1.xls" folderPath = "C:Documents and settingsacsMy DocumentsEntry" I want to enter these two paths in a sheet in my excel report file (For example, I am running the report from Report1.xls, in which there is a sheet name "Filepaths". In this, in B5, I would like to enter the Filepath (B5 named as "FILEPATH") in B6, I would like to enter the Folderpath (B6 named as "FOLDERPATH") So that, if I am copying the folder to another area, I no need to change the code every time in the VBA editor. I can do changes in these cells and it will be taken as the path to run the code further.
View Replies!
View Related
Autocomplete In A Textbox Using Vba
I have an excel file with a large amount of data. It is used to keep track of our firms past and current projects (on each row). The columns include data such as the name of the client and the city in which the project is located. The excel sheet is set up with filters, so that it is easy to check which jobs we've done for client 'X', for instance, or the jobs initiated since a certain date. In order for the filters to work properly, we need to make sure that, as an example, teh client name has to always be inputed in the same manner. Using excel's autocomplete option works well for this. New projects are added to the top of the list. So, a new row has to be added each time a new project is inputted. In order to automate things, I've made a userform with text/comboboxes in which the data for the new project is inputted and then placed onto the sheet once the userform is closed. My question is this: Is there a way to have the text/comboboxes on the userform use the autocomplete feature? As an example, if I'm entering the client name for a new project, is there a way to have the textbox autocomplete the client name by checking in the client column on the sheet? And, if there is more than one client starting with the same letter, is it possible to make a listbox appear showing all the clients beginning with that letter so the correct one can be picked? Since the list of clients will always be changing, I don't want to code a certain set list, or have to continually update a list. (besides, the amount of coding would be huge considering the number of clients I would have to give it's own .AddItem)
View Replies!
View Related
Vba Sum Up Textbox Entries
I try to sum up values a user enters into 3 different textboxes using the following cells(1,1) = userform.textbox1.value + userform.textbox2.value + userform.textbox3.value Let's imagine the user enters "10" into each of the three textboxes, cell a1 should contain 30, however, what i get is 101010.
View Replies!
View Related
Adding Macro To TextBox In VBA
I've got a userform which adds Textboxes automatically depending on a certain value. And the amount of Textboxes varies from 1 - 100. I add them with the line: Set MyControl = UserForm1.Frame1.Controls.Add("forms.textbox.1", strControl, Visible) Now my question is: Can I add a macro to each of these textboxes automatically? A macro for the Change event I think it is. All textboxes would have the same macro. I kinda hoped it would be one of the following: MyControl.OnAction = "test" MyControl.Change = "test"
View Replies!
View Related
Reference A Userform Numbered Textbox In Vba
Is there a way i can use a userform Textbox labeled jobNum1 in vba code with a counter "ctr" something like jobNum(ctr) = 5. I basically have multiple jobNum textboxes labeled jobNum1, jobNum2, jobNum3.....etc and would like to repeat the code for each counter until reaching 5. Take the following sub:
View Replies!
View Related
VBA Code To Filter Listbox As You Type In A Textbox
I have a list of customers in listbox1 (the text values of which come from a spreadsheet), that I want to refine as I type in textbox1. I'm not sure if it's possilbe, but I would like it to work similar to the itunes search (if you're familiar with it) where it searchs for any occurance of the text within the list as opposed to just searching for the letters at the beginning of the word.
View Replies!
View Related
Create Graph Using VBA
I want to create excel graph using VBA and found difficulties on chart name set to default. the script is like this : ActiveSheet.ChartObjects("Chart 31").Activate Can I set my own name of the chart instead of "Chart 31" (excel default) ?
View Replies!
View Related
VBA To Create New Sheet ...
I would like to be able to have a macro, linked to a button, so that when you press that button it creates a new named sheet based on data in a particular cell. I.e. There is a table with the following data: Apples (A1) Oranges (A2) Pears (A3) There are also the sheets Apples, Oranges & Pears. You enter 'Grape' in cell A4, then when you press the button it creates a new sheet named Grape. Also when a new sheet is created, the 'input cell', in this case A4, is moved down one so that when the next sheet is needed to be added, it doesn't just add the same sheet (i.e. in the example above, we don't end up with a new sheet named 'Grape' each time we click the button).
View Replies!
View Related
Create Tag In VBA?
I found this really cool code that creates a tag cloud in Excel using VBA. It's far too complex for my understanding but I was hoping I could get some of the experts opinions on here about modification possibilities. I have attached the macro-enabled 2007 workbook. What I am trying to do is search through a list of keywords and determine each keyword's density within a list. The list for example could look like this: slow windows xp windows xp running slow windows xp computer [slow windows xp] [windows xp running slow] [windows xp computer] [computer running slow windows xp] "computer running slow windows xp" "slow windows xp" "windows xp running slow" "windows xp computer" You'll notice the characters " [ ] of which I would like to ignore when the cloud builds. The cloud would list the most dense keywords first, and gradually decrease to the least dense keywords. The macro code is inside the workbook but I'll list it here to:
View Replies!
View Related
|
TRACKER
