Form to Text File

**rp1783** · 04-11-2016, 05:38 PM

I'm going to describe this the best way I can. I have a text file I'm currently using as a template. There are several areas of the text file that I need to change and then I save it and ultimately copy and paste it to a different program. What I'm looking for is having an excel form where there are fields I can type in and when I submit it allows me to download a text file. Most of the text is static and never changes there are maybe 3 or 4 items in the text that changes. I may not be explaining this very well. Thanks in advance.

**rp1783** · 04-11-2016, 05:49 PM

To help illustrate what I'm trying to accomplish a little better. I've attached a text file. The area that says NUMBERSHERE and TEXTHERE would be what I would want to add to the form. Submitting the form would spit out the completed txt file.

**bulina2k** · 04-11-2016, 06:18 PM

Here is the code:

Option Explicit

Private Sub CommandButton1_Click()
Dim fs As Object
Dim a As Object
Dim text As String, folderpath As String
Unload UserForm1
    Set fs = CreateObject("Scripting.FileSystemObject")
    folderpath = "C:\Users\Bogdan\Desktop\excelforum\rp1783\"
    Set a = fs.CreateTextFile(folderpath & "configfile.txt", True)
    text = Me.Label1.Caption & Me.TextBox1.text & vbCrLf & _
    Me.Label2.Caption & Me.TextBox2.text & vbCrLf & _
    Me.Label3.Caption
    a.WriteLine (text)
    a.Close

Call Shell("explorer.exe" & " " & folderpath, vbNormalFocus)

End Sub

And the attached file

**rp1783** · 04-11-2016, 06:30 PM

Form looks great. When I submit it opens the folder I specify, but it doesn't create the file.

**bulina2k** · 04-11-2016, 07:16 PM

I have no clue why this is happening, could it be write rights on the folder? Is it somewhere on the network?

Form to Text File

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Form to Text File

Re: Form to Text File

Re: Form to Text File

Re: Form to Text File

Re: Form to Text File

Thread Information

Users Browsing this Thread

Similar Threads

VBA code for pulling a sequential number from a text file dependent on a form entry.

Pull Worksheet Cell Data into a User Form Text box and have it update as the form is fille

[SOLVED] Help me streamline my code? Determine form button background from form text box

Export Excel Form Data to Text File

Open Word file form Excel using VBA and file path

looping, Open text file, copy text, close text file

Parsing a text file to a excel or word form

[SOLVED] Adding text file to a user form?

Bookmarks

Bookmarks

Posting Permissions