Write contents of immediate window to a text file
Solution 1
Here's my suggestion: write to the immediate window AND to a file at the same time. Examples below.
Why make the information first transit in the immediate window, and only then write it to a file from there? That just sounds perversely and uselessly difficult!
Dim s As String
Dim n As Integer
n = FreeFile()
Open "C:\test.txt" For Output As #n
s = "Hello, world!"
Debug.Print s ' write to immediate
Print #n, s ' write to file
s = "Long time no see."
Debug.Print s
Write #n, s ' other way of writing to file
Close #n
Dim FSO As Scripting.FileSystemObject
Set FSO = New Scripting.FileSystemObject
Dim txs As Scripting.TextStream
Set txs = FSO.CreateTextFile("C:\test2.txt")
s = "I like chickpeas."
Debug.Print s ' still writing to immediate
txs.WriteLine s ' third way of writing to file
txs.Close
Set txs = Nothing
Set FSO = Nothing
Note that this last bit of code requires a reference to be set: Tools > References > checkmark at Microsoft Scripting Runtime.
Solution 2
Put this code to immediate window and hit enter to write the List to JSON text in C#.
System.IO.File.WriteAllText(@"C:\Users\m1028200\Desktop\Json2.txt",
JsonConvert.SerializeObject(resultsAll));
Related videos on Youtube
Shayon Saleh
Updated on June 04, 2022Comments
-
Shayon Saleh about 2 years
I'm writing a macro which goes through a document and tries to parse it by Style. Right now, anything in the designated style is copied onto the immediate window. Is there a way to automate the macro further to move the text from the immediate window into a txt file? Otherwise, anyone using the macro would not be able to see the text unless they opened up VBA, correct?
-
Jean-François Corbett almost 13 yearsI don't understand why you would want to have the information first transit in the immediate window, and only then be written to a file from there. Why not write to file directly??
-
-
Oscar Anthony almost 7 yearsHello, thanks for the answer! I have a question: is there any advantage/inconvenient in using one of the methods instead of another?
-
Jean-François Corbett almost 7 yearsYes. I suggest reading up on them and trying them out. Personally, I almost always use the
FileSystemObject
method. -
HackSlash over 4 yearsThis is a VBA question.