How to create LOG file for commands executed in VB..?

D

Dayanand

Hi All

Please help me out in creating log file for which ever commands are executed in Visual Basic during run time

Regard
Dayanan
 
K

Kevin Beckham

Add the procedure

Sub AddToLog(strMsg As String)
Dim fid As Integer
Const logfile = "c:\temp\vbalog.txt"

fid = FreeFile()
Open logfile For Append As #fid
Print #fid, strMsg
Close #fid
End Sub

then add calls to it where you need to record your code
Open then Close to ensure file isn't lost if Excel crashes

Kevin Beckham
-----Original Message-----
Hi All,

Please help me out in creating log file for which ever
Click to expand...
commands are executed in Visual Basic during run time.
 
D

Dayanand

Hi Yogendra,
Thanx for u r response. Actually i have built an application in VB in which i am calling multilple call functions. Now my requirement is that, when ever i run my application.... a text file should be created on desktop and in thet current date and logging date has to be printed and then onwards which ever VB commands are going to be executed in my application, all those should be line by line logged to the text file.
Hope u got my point.
Could u please give me solution..?

Regards
Dayanand
 
D

Dayanand

Hi Kevin
Thanx for u r reply. But can u please guide me to create new text file every time i run my application and log the data. Which ever u have sent code will append the data to the existing log file. Is it possible to remove the old content and append new content or is it possible to create new text file..?

Regard
Dayanand
 
C

Chip Pearson

Dayanand,

Change the "For Append" to "For Output" in the Open statement.
This will delete the contents of the file when it is opened.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



Dayanand said:
Hi Kevin,
Thanx for u r reply. But can u please guide me to create new
Click to expand...
text file every time i run my application and log the data. Which
ever u have sent code will append the data to the existing log
file. Is it possible to remove the old content and append new
content or is it possible to create new text file..?.
 
Top