Macro That Automatically Creates Txt File

  • Anybody willing to help me create a macro that will:


    1. create a txt file named "scope.txt"
    2. first line of text file is blank and second line with the information, "append /var/user/"
    3. automatically saves and closes the txt file.


    Thank you in advance!

  • Re: Macro That Automatically Creates Txt File


    Turn on your macro recorder. Create a new workbook. Write the information mentioned in it. Do a file -> save as -> text, writing the name scope in the box. (I think tab-delimited "might" work better than Unicode text, because I once used a similar method to create a batch file to ping some IPs and had problems with one or the other.)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!