Join or sign in Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below. Use Your Email Use FacebookUse Linkedin

VBA 5 help

Locked

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

Topic

VBA 5 help

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!

VBA 5 help

In reply to VBA 5 help

The question was auto-closed by TechRepublic

VBA 5 help

In reply to VBA 5 help

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

VBA 5 help

In reply to VBA 5 help

The question was auto-closed by TechRepublic

VBA 5 help

In reply to VBA 5 help

This question was auto closed due to inactivity

[Author]

Replies