| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
create .TXT file Log
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create card file from csv file | Excel Discussion (Misc queries) | |||
| How do I create a CSV file? | Excel Discussion (Misc queries) | |||
| Code to create dbase file from text file? | Excel Discussion (Misc queries) | |||
| Possible to create XL file then run XL VBA (to format & filter XL file) from Access VBA? | Excel Discussion (Misc queries) | |||
| Create a single xls file with each import csv file having its own tab | Excel Discussion (Misc queries) | |||
![spence[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
