Write log file

[Josh]

Is it possable to write some log information while running code in my excel
project? I would like to write some basic information incase I have a
problem or sut to write how many times a function is called?

TIA

Josh

 

[Rowan Drummond]

Hi Josh

If you are just wanting to keep track of how many times a function is
called it would probably be easier to print to the immediate window
(Ctrl G to view it in the VBE) than to create a log file.

Insert the appropriate line in your function:
Debug.Print "Myfunction ran" 'or whatever


Hope this helps
Rowan

 

[Tom Ogilvy]

If you actually want to write a text/log file:
http://support.microsoft.com/default.aspx?scid=kb;en-us;151262&Product=xlw
Working with Sequential Access Files

http://www.applecore99.com/gen/gen029.asp
File I/O Using VBA
Applecore pages on Microsoft Access

http://support.microsoft.com/default.aspx?scid=kb;en-us;172267&Product=vb6
SAMPLE: RECEDIT.VBP Demonstrates File I/O in Visual Basic

 

[Robin Hammond]

Josh,

I just happened to have something like that from an old VB project, so I've
just put it up on my site for general consumption. Let me know if it works
for you.

http://www.enhanceddatasystems.com/ED/Pages/ExcelLogHandler.htm

Robin Hammond
www.enhanceddatasystems.com