write into a text file as log

Andrew XJ · Mar 15th, 2002, 08:27 PM

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 · Mar 15th, 2002, 09:27 PM

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 · Mar 15th, 2002, 09:33 PM

Thx, that example is quite good.

Tom Urtis · Mar 15th, 2002, 09:44 PM

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 · Mar 15th, 2002, 09:48 PM

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

Tom Urtis · Mar 15th, 2002, 09:51 PM

Hey, there it is; have a nice weekend.

Mar 15th, 2002, 09:44 PM	#4
Tom Urtis MrExcel MVP Join Date: Feb 2002 Location: San Francisco, California USA Posts: 10,387	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!! __________________ Tom Urtis Microsoft MVP - Excel

Mar 15th, 2002, 09:48 PM	#5
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Yeah, I got logged out and forgot to check the autosig box, is this better? __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Mar 15th, 2002, 09:51 PM	#6
Tom Urtis MrExcel MVP Join Date: Feb 2002 Location: San Francisco, California USA Posts: 10,387	Hey, there it is; have a nice weekend. __________________ Tom Urtis Microsoft MVP - Excel

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 15th, 2002, 08:27 PM	#1
Andrew XJ Board Regular Join Date: Feb 2002 Location: Singapore Posts: 77	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.

Mar 15th, 2002, 09:27 PM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Have a look at the help file for the "OpenTextFile" method, it's got a better example than I can make up for you.

Mar 15th, 2002, 09:33 PM	#3
Andrew XJ Board Regular Join Date: Feb 2002 Location: Singapore Posts: 77	Thx, that example is quite good.