Hi, I am new to excel VBA. I am trying to write a code to copy a range of text from One text file to another . For instance : I have a textfile 1 with data some data ... some data ... some data... Textfile 2 some data ... empty some data... I have to copy lines from to and paste the same in the textfile2 inside same to . I am clueless to write a code for this . Can you please help me with this proces Thanks for your valuable advices.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Copy Paste a range from one textfile to another

Thread starter chandrup23
Start date Feb 26, 2018
Tags

copy data startaction text textfile

chandrup23

New Member

Feb 26, 2018

Hi, I am new to excel VBA.

I am trying to write a code to copy a range of text from One text file to another .

For instance : I have a textfile 1 with data

some data ...
< startaction>
some data ...
< \ startaction>
some data...

Textfile 2

some data ...
< startaction>
empty
< \ startaction>
some data...

I have to copy lines from < startaction> to < \ startaction> and paste the same in the textfile2 inside same < startaction> to < \ startaction> .

I am clueless to write a code for this . Can you please help me with this proces

Thanks for your valuable advices.