+ Reply to Thread
Results 1 to 5 of 5

Create A Text File Generator from Userform

  1. #1
    Registered User
    Join Date
    04-25-2015
    Location
    Indonesia
    MS-Off Ver
    MS Office 2010
    Posts
    8

    Create A Text File Generator from Userform

    Hi Guys,

    I really need your help to create a text file generator from User Form. The point is, when the Add data button clicked, it will automatically create a text file with file name "notes"&value in file_no TextBox.txt and stored in the directory which is the value in the path_box TextBox. Herewith I attach the excel files and complete instructions in MS word.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Create A Text File Generator from Userform

    Sorry try this:


    Please Login or Register  to view this content.
    Last edited by mehmetcik; 05-03-2015 at 05:59 AM.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    04-25-2015
    Location
    Indonesia
    MS-Off Ver
    MS Office 2010
    Posts
    8

    Re: Create A Text File Generator from Userform

    Quote Originally Posted by mehmetcik View Post
    Please Login or Register  to view this content.
    Hi mehmetcik,

    Thank you for your reply. Actually There's an error when the add button clicked,with message: "Compile Error: Expected Function or Variable" and it highlighted the path_box_Change
    Please Login or Register  to view this content.
    Is there something wrong, or maybe I made a mistake with the code?

  4. #4
    Registered User
    Join Date
    04-25-2015
    Location
    Indonesia
    MS-Off Ver
    MS Office 2010
    Posts
    8

    Re: Create A Text File Generator from Userform

    Hi mehmetcik,

    The code still not working. There's compile error: expected function or variable and highlighted the path_box_Change.

  5. #5
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Create A Text File Generator from Userform

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Using buttons to create a text generator in a field
    By bigapple14 in forum Excel General
    Replies: 1
    Last Post: 04-21-2015, 10:25 AM
  2. Create Notepad file from Userform.
    By pipoliveira in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-26-2015, 06:54 AM
  3. Create text file from excel and use a cell value as text file name
    By tk636 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-27-2014, 06:47 PM
  4. How to Create a Random Generator
    By Justair07 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2013, 04:30 PM
  5. generator of files with userform and Access
    By kengfak.chhan@bnc.ca in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-11-2013, 04:03 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1