Write log file
 

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

Write log file
 

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

Josh wrote:
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

Write log file
 

If you actually want to write a text/log file:
http://support.microsoft.com/default...62&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...67&Product=vb6
SAMPLE: RECEDIT.VBP Demonstrates File I/O in Visual Basic

--
Regards,
Tom Ogilvy


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

Write log file
 

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/E...LogHandler.htm

Robin Hammond
www.enhanceddatasystems.com

--
Robin Hammond
www.enhanceddatasystems.com
"Josh" wrote in message
...
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