Hi All,

This may be a fairly basic question, but I'm just not sure how to do
this:

I have an Excel file with data that needs to be input into a text
file. The text file already has various lines that need to stay in,
and the data from Excel needs to be put into specific places in the
file.

For example, the data from A2 needs to go into the text file
immediately after a phrase, then the data from B2 needs to go after
another phrase, and so on.

Is there an easy way to accomplish this? I keep thinking it's
something like a MailMerge, but I don't know how to accomplish this.

Are there any pointers?

Thanks,
David

Hi, there is no easy way. You have to write a VBA code snippet, that reads
the text file and writes the contents into another file alongwith the values
read from the excel and finally after all the lines from the first text file
is written into the second text with the data from excel, delete the first
text file and rename the second text to the name of the first text file. I
hope this helps you.

" wrote:

Hi All,

This may be a fairly basic question, but I'm just not sure how to do
this:

I have an Excel file with data that needs to be input into a text
file. The text file already has various lines that need to stay in,
and the data from Excel needs to be put into specific places in the
file.

For example, the data from A2 needs to go into the text file
immediately after a phrase, then the data from B2 needs to go after
another phrase, and so on.

Is there an easy way to accomplish this? I keep thinking it's
something like a MailMerge, but I don't know how to accomplish this.

Are there any pointers?

Thanks,
David