Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello everyone,
I have an inputbox in VBScript, where the user inputs a location of a file. If possible I'd like the info they enter to be added to a text file. Any ideas? Thanks, proedrsmith *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This is in VB script from an ASP page. You need windows scripting installed,
but you must have that to have posed the question. Dim fso, f,strfile strfile = "Path to your file here" Set fso = createobject("Scripting.FileSystemObject") set f = fso.opentextfile(strfile,8,true) f.writeline "Your text here from the text box" f.close -- Robin Hammond www.enhanceddatasystems.com Check out our XspandXL add-in "Proedrsmith" wrote in message ... Hello everyone, I have an inputbox in VBScript, where the user inputs a location of a file. If possible I'd like the info they enter to be added to a text file. Any ideas? Thanks, proedrsmith *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
http://support.microsoft.com/support...eio/fileio.asp
File Access with Visual Basic® for Applications Regards, Tom Ogilvy "Proedrsmith" wrote in message ... Hello everyone, I have an inputbox in VBScript, where the user inputs a location of a file. If possible I'd like the info they enter to be added to a text file. Any ideas? Thanks, proedrsmith *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sub AddText()
Dim S As String Dim i As Integer S = InputBox("Now what") If S < "" Then i = FreeFile Open "C:\Temp\MyLogg.txt" For Append As #i Print #i, S Close #i End If End Sub -- HTH. Best wishes Harald Excel MVP Followup to newsgroup only please "Proedrsmith" skrev i melding ... Hello everyone, I have an inputbox in VBScript, where the user inputs a location of a file. If possible I'd like the info they enter to be added to a text file. Any ideas? Thanks, proedrsmith *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding text without erasing previous text? | Excel Discussion (Misc queries) | |||
Comparing text and then adding numbers if the text matches | Excel Worksheet Functions | |||
Adding Dashes in front of text using text formating | Excel Discussion (Misc queries) | |||
Can Text in an InputBox appear as asterisks? | Excel Discussion (Misc queries) | |||
Adding Data from EXCEL to a TEXT file | Excel Programming |