bcsmess
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.
Thanks.
:)
Sorry... just noticed you have replied.
OK, we'll carry on here, if you wish to close/grade the other question.
Thanks.
Sorry... just noticed you have replied.
OK, we'll carry on here, if you wish to close/grade the other question.
Thanks.
"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.
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.
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.
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I posted another comment this morning for clarification...
https://www.experts-exchange.com/questions/21476447/Extract-Word-Lines-into-Excel.html