General discussion

  • Creator
    Topic
  • #2074667

    VBA 5 help

    Locked

    by ash ·

    I was asked to make a Sercurity login program, that would run up upon start up of the computer.
    It also had to have a logbook, one that recorded fake attemps.
    Then i hit a problem. Every time the computer is restarted, the logbook rewrites the data in the file.
    If I use brinary, I cant read the file with out VB. If I use output, it will rewrite the book.
    Help would be accepted.
    Ash

All Comments

  • Author
    Replies
    • #3778908

      VBA 5 help

      by tclere ·

      In reply to VBA 5 help

      Instead of using:

      Open(“Yourfile.txt”) for Output As #1
      Write #1, YourStuff

      Use:

      Open(“Yourfile.txt”) for Append as #1
      Write #1, YourStuff

      This will append YourStuff to the end of the file instead of rewriting the file each time the program is run.

      Hope this is what you were looking for!

      • #3754547

        VBA 5 help

        by ash ·

        In reply to VBA 5 help

        The question was auto-closed by TechRepublic

    • #3778795

      VBA 5 help

      by webmaster ·

      In reply to VBA 5 help

      I would definitely use a TXT file for your loggin, because of its simplicity and the append function.

      • #3754548

        VBA 5 help

        by ash ·

        In reply to VBA 5 help

        The question was auto-closed by TechRepublic

    • #3754546

      VBA 5 help

      by ash ·

      In reply to VBA 5 help

      This question was auto closed due to inactivity

Viewing 2 reply threads