Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open CSV file, format data and write output to a text file. | Excel Programming | |||
How to write to a template txt file | Excel Programming | |||
How can I Write this to a CSV File Please | Excel Programming | |||
Write Text File | Excel Programming | |||
write to external file | Excel Programming |