How do you drop the " from write#1?

[AdamOnAccess]

I have to load a string of text into a text file and then open the file in notepad. Here's my code:

newTxt = "C:\PathTo\newTxt.txt"
Open newTxt For Output As #1
Write #1, stringOfText_variable
Close #1

FollowHyperlink newTxt

Everything works fine accept one thing. Quotes are appearing before and after the text and I can't seem to get rid of them. The finished text file always looks like this..

"
line one of text
line two of text
line three of text
"

It looks like these quotes are coming from the Write #1 statement. I've tried using MID function to lop them off before the Write #1 statement, but it didn't work... it lopped off the first and last character of text, but left the quotes.

Does anyone know how to get rid of those quotes?

thanks
Adam

[missinglinq]

Yes, Adam, it is coming from the Write statement. This is the normal behavior when you write to a text file from VBA, like the carriage return/linefeed you've already had problems with. Programs retrieving/using the data have to have some way to tell where one piece of data ends and the next piece begins. I'm not aware of anything you can do to deal with the problem before writing to the file. My guess would be that you'll have to deal with it on the other end, when you're retrieving the data.

Linq ;0)>

[Megalog]

Use Print #1 instead of Write #1 and you'll get no quotes.

[missinglinq]

Good going,Megalog! I remembered that from the old Basic days (when Basic wasn't visible) and tried to amend my post, but the site is apparently experiencing access (access with no capital "A") problems again!

Linq ;0)>

[AdamOnAccess]

Thank you both. It worked like a charm.
Adam

[Megalog]

Glad to help. Little differences like that can be real frustrating sometimes.

[NeoPa]

If you look up Print # in the Access Help system you'll find a bunch about that and related ways of direct input / output (See also).

As Linq says, this is pure Basic and not related to the applications at all (works across all office applications).

Welcome to Bytes Adam :)