Write statement 2

[finitesimian]

I'm trying to make a script that writes to a txt file on my desktop. I've figured out the script for opening/closing and writing to the txt document, but I'm needing it to do a couple of other things:


1. write each new expression to a new line (next line down) instead of overwriting the existing occupied lines on the .txt file.

2. If possible, write without quotation marks/delimiting characters.


also-- I could have sworn I saw a code here a while back for writing to an open document, but I was never able to find that thread.

 

[IknowMe]

Post your code

1. write each new expression to a new line (next line down) instead of overwriting the existing occupied lines on the .txt file.
Open FName$ For Append As FNum%
should do it.

2. If possible, write without quotation marks/delimiting characters.
post your code
also-- I could have sworn I saw a code here a while back for writing to an open document, but I was never able to find that thread.
What type of document?

Wow, I'm having amnesia and deja vu at the same time.
I think I've forgotten this before.

 

[finitesimian]

Thanks for the tip

Here is one example

Dim op1 As String 
op1 = "This is my output"
Open "C:\Documents and Settings\myuserprofile\Desktop\scrape.txt" For Append As #1
    Write #1, op1 
    close 1

I want it to write: This is my output instead of "This is my output" (no quotation marks anything-- just the string by itself)

-----
As for which kind of document, it's a .txt file.

 

[Skie]

Use Print #1 instead of Write #1 to not have quotes.