Sending Data To A Text File

[JonRowland]

Can anyone help, I can't seem to find an easy solution.

I am looking to have a macro that will select copy some text and then send it into a text file.

What VBA would I need to open and paste into the text file?

Cheers

Jon

 

[JonRowland]

I'm sending this to the top in case those state side missed it and coudl help

 

[vconfused]

Can you open the text file in Excel, make changes, then save it again?

 

[Norie]

Jon

I'm sure it's possible but some further details could be helpful.

 

[JonRowland]

Hi,

I try my best as explaining what I am looking to do.

The user enters some text.
The text entered is user to create some SQL for a database query. Currently this is copied out manually into a SQL import file which contains some other SQL needed to the query.
What I want is for Excel to output column C into a text file, saving on the user from manually copying it.

Hope that's clear.

Jon

 

[pcc]

try this or adapt to suit

Sub write_to_file()
Dim f As Integer
f = FreeFile
fname = "c:\youfile.txt" ' change to suit
   Open fname For Output As f
   c = 3
   r = 1
   Do Until IsEmpty(Cells(r, c))
          Write #f, Cells(r, c)
        r = r + 1
        Loop
         Close #f
End Sub