Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Output to Notepad
I have some inputboxes prompting the user for certain
values. I would like these values to be saved in a text file. Is there some way this can be done? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Output to Notepad
Dim myCriteria As String
Dim myOutText As String Dim tmpfileName As String tmpfileName = "C:\Program Files\YourFile.txt" 'Open tmpfileName For Output As #1 - to clear and start fresh Open tmpfileName For Append Access Write As #1 myOutText = "What ever..." Write #1, myOutText Close #1 That is what I have used in the past. Keith www.kjtfs.com --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Notepad to excel | Excel Discussion (Misc queries) | |||
Pasting from Notepad | Excel Discussion (Misc queries) | |||
notepad to excel | New Users to Excel | |||
DDEInitiate with Notepad | Excel Programming | |||
notepad in excel | Excel Programming |