create .TXT file Log

S

spence

i have this to create a txt file in excel's program files
directory. how can i modify it to put the txt file on my
C:\ drive.


Private Sub workbook_beforeclose(cancel As Boolean)
Open Application.Path & "\Log.txt" _
For Append As #1
Print #1, "Stopped " & Now
Close #1
End Sub

TIA
 
M

MicMast

or make a var above, something like this:
loc = application.path & "\Log.txt"
open loc for...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Making a macro only work on certain files 2
Which Excel event to call when opening a .txt file 1
Use external file variable in formula 2
Auto_open User Name Log 2
batch file to ftp code not running - please help! 0
Making a field compulsary before user leaves sheet 3
.txt import + saveas + mkdir 3
reading and replacing just the first line of a txt or csv file XL2 1

Top