Hi All

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

Regard
Dayanan

can you please describe it a bit further?

Dayanand wrote:

Hi All,

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


Regards
Dayanand

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
commands are executed in Visual Basic during run time.


Regards
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

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

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" wrote in message
...
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..?.

Regards
Dayanand