write into a text file as log

[Andrew XJ]

Could you tell me how to write into a text file several lines every day as a log file using VBA? The invoker is a procedure in a VBAProject.

 

[Mark O'Brien]

Have a look at the help file for the "OpenTextFile" method, it's got a better example than I can make up for you.

 

[Andrew XJ]

Thx, that example is quite good.

 

[Tom Urtis]

Hey Mark, your green-colored signature is missing, and we're still 2 days from March 17!! What gives? I swore I saw it on your posts earlier today!!

 

[Mark O'Brien]

Yeah, I got logged out and forgot to check the autosig box, is this better?

 

[Tom Urtis]

Hey, there it is; have a nice weekend.