asked on

VBA Word Pasting Question

Is there a way using VBA to extract say Lines 1-200,000 in a Word document and paste it into Excel.

Thanks.

Was there a problem with my code in your previous question (# 21476447)?

I posted another comment this morning for clarification...

https://www.experts-exchange.com/questions/21476447/Extract-Word-Lines-into-Excel.html

[ fanpages ]

:)

Sorry... just noticed you have replied.

OK, we'll carry on here, if you wish to close/grade the other question.

Thanks.

[ fanpages ]

"but yes, for number 2, that is what i mean, except the minor change is that i wish to place the data in col. A, then 5 lines over into Col F, then 5 lines over into Col K..."

So, fill lines from Word from A1 to A5, then F1:F5, then K1:K5?

Sorry... I'm still not 100% on what you are looking for as a result.

Perhaps an example pasted in a reply would be useful?

BFN,

fp.

bcsmess

ASKER

so I probably have about 200,000 lines in word to extract. I'd like to run your program to fill Col. A as much as possible which would be 65536 rows max, then start pasting at row 1 5 columns over in Col. F until column F is full, and then start pasting at row 1 5 col. over in Col. K until K is full and so on until all my data has been pasted.

Thanks.

ASKER CERTIFIED SOLUTION

[ fanpages ]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

[ fanpages ]

Thanks for your grading.

Happy codin',

BFN,

fp.
[ http://NigelLee.info ]