vba writeline method

[hgchas]

hi everyone- I wanted to reach out and see if anyone has experience using the writeline method on Excel VBA.

this is what I am trying to accomplish: writeline ('input text here,' 'insert Excel range', 'insert end text') all to write to a text file.

thanks in advance

[TMS]

No, not as such. I've used other methods to write to text files.

However, see: https://docs.microsoft.com/en-us/off...tstream-object

[Marc L]

if anyone has experience using the writeline method on Excel VBA.

Yes but as it depends on your source data worksheet and the expected text file result
and after all as we are not on a mind readers forum …

[Norie]

If you want to write the values from range of multiple cells to a text file then you are going to have to do some work with those values.

For example, do you want to concatenate them with a delimiter?

List each value on it's own line?

[hgchas]

hi everyone, thanks for the response.

this is the code I am working with

Please Login or Register  to view this content.

[Norie]

That doesn't really tell us how you want to write the values from the range to the file.

[hgchas]

writeline ('input text here,' 'insert Excel range', 'insert end text') 'this is the area I want to utilize

I want to have the code write out the line with the range, something like this: "These are the values I want to show you all, Range(A1:A). Let me know if you have questions."

[Norie]

How would you want the values in the range to appear in the text file?

[hgchas]

Hi- I would like for the values in Range (A1:A) to appear embedded in between the two texts.

[TMS]

Try

Please Login or Register  to view this content.

[hgchas]

It did not function stating it was a mismatch error.

[TMS]

Please Login or Register  to view this content.

[TMS]

For completeness ...

Please Login or Register  to view this content.

[hgchas]

Thank you! This seemed to work

[TMS]

You're welcome.

[TMS]

Please keep all questions in the thread. For the benefit of others, do not PM contributors or solution providers.

hello-I'm sorry to bother, I had a quick question on an error I am getting.

IT IS HERE, I AM TRYING TO ADD " " TO SURROUND THE RANGE WHEN IT GENERATES THE TXT FILE-LIKE THIS "RANGE(A1:A10)"= "123," "345," "567," ETC.

This seems to do what you want. You may need to tweak which spaces to include or leave out.

Please Login or Register  to view this content.

The output looks like this: