This video provided every step necessary to copy my data from a Word document into an Excel spreadsheet. I can assure you I will be back to watch this a few more times in my ventures of uploading data into an Excel format. Thank you!

This is new to me. I have never used this before. I have to admit this confuses me however this video helped me gain knowledge of this topic.

Copying Data from Microsoft Word to Excel using Excel VBA is all new to me. The video gave a great explanation but I need to try this on my own to get it

Thank you for this, helped a lot !

Thanks a lot. Great explanation! Can I save both Word File and Excel file on cloud (OneDrive/DropBox etc'...) and use it from my/Others Mobile phone in order to collect data from different users via the Word document ?

This information is new to me, but appears to be very helpful tool.

Great help, can you think of a way to do this without content controls in multiple word documents? For example a client gives us 10 files 1.doc through to 10.doc and we want to copy two ‘fields’ in the word document and put them into excel. The routine should be able to process many files in a folder

hi! how can I get data from txt file? no tables! I mean like I would open Notepad, select all, copy it and paste it to excel - how could I do that?

I'm getting run time error 91 for that line including Sheets("Data").Cells(r,2)....

where can i get code in video?

@niraj162

5 жыл бұрын

Sub dataFromWord() Dim wordApp As Word.Application Dim wDoc As Word.Document Dim r As Integer Set wordApp = CreateObject("word.application") Set wDoc = woniApp.Documents.Open(ThisWorkbook.Path & "/" & Range("E 1 ").Value & ".docx") wordApp.Visible = True r = 2 For i = 1 To 10 Sheets("Data").Cells(r, 2) = wDoc.ContentControls(i).Range.Text r=r+1 Next i wordApp.Documents.Close wordApp.Quit End Sub

eres una riata !! thanks

Does not work on Mac