j.smith1981
10-05-2009, 03:32 AM
How do I get VBA in Excel to detect if a txt file exists.
Then if it doesnt create one called timer.txt
Write the start of the macro in a time format like so:
Started: 05/10/2009 11.30
Then at the end, open that txt file put a new line and put the finishing time again like so:
Finished: 05/10/2009 11.45 (whatever time the macro finishes)
Then allow it to add another below that leaving a new blank line below each time it is run, how is this possible please?
Thanks in advance again.
Then if it doesnt create one called timer.txt
Write the start of the macro in a time format like so:
Started: 05/10/2009 11.30
Then at the end, open that txt file put a new line and put the finishing time again like so:
Finished: 05/10/2009 11.45 (whatever time the macro finishes)
Then allow it to add another below that leaving a new blank line below each time it is run, how is this possible please?
Thanks in advance again.