Excel and Word - VBA to Copy Word document to excel sheet

[Plokimu77]

Hello Forum,

1)
Is it possible to have a code that will copy all the text in a word document that is located in a folder
and paste it on cell A1 in a excel sheet?

2)
If the above is possible, what if i have multiple word documents in a folder
and i would like them all pasted in individual sheets in the same Excel spreadsheet.
One sheet for each word document.

Thank you for any assistance that can be provided.

 

[Macropod]

Technically, yes, provided the document isn't too large, but you'd be liable to lose all the document formatting, as well as headers, footers, footnotes, tables, textboxes, pictures, etc.

 

[Plokimu77]

Awesome. Would you be able to provide assistance with the code?

 

[Macropod]

Just to clarify: you want the contents of the entire document in cell A1, not separate cells for each paragraph?

 

[Plokimu77]

Yes sir.

When performing the task manually, I select all the text on the word document and just paste on cell A1 in excel.

Thank you.

 

[Macropod]

You have not answered my question. Even when you do the copying & pasting manually, the pasted content could all end up in one cell or with each paragraph on a new row - it all depends on the method you use.

 

[Plokimu77]

Each line in the paragraph goes on a new row.

If a paragraph in the word document has 5 lines, each line ends up in its own individual row in the excel sheet. 5 lines in word document = 5 rows in excel sheet.

 

[Macropod]

Well, that's entirely different to what you previously said and would require a lot of extra work to implement. That's because Word documents don't work with lines - they work with paragraphs whose lines change according to whatever changes you might make to the page layout and according to whatever printer driver you're using.

 

[Plokimu77]

10-4

I will put the idea to rest.

Thank you for your insight and for trying to help.