Results 1 to 6 of 6

Create new textfile with command button

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-17-2009
    Location
    PA USA
    MS-Off Ver
    Excel 2000
    Posts
    184

    Create new textfile with command button

    The attached workbook has a user form with a command button. The command button opens an existing textfile into Notepad. The textfile is located in the folder defined by the HOME environment variable.

    Now, if the textfile does not exist, I would like to:

    1. create a new textfile
    2. write string variables to it line by line
    3. save the textfile
    4. open the textfile in Notepad

    Thanks for any help.

    Excel 2000
    Attached Files Attached Files
    Last edited by proepert; 04-27-2010 at 07:07 AM.

Thread Information

Users Browsing this Thread

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

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