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!
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
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
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 ?
![ROSÉ (로제) - number one girl [더 시즌즈-이영지의 레인보우] | KBS 241129 방송](http://i.ytimg.com/vi/A9oByH9Ci24/mqdefault.jpg)
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
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
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 ?
Thank you for this, helped a lot !
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?
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
This information is new to me, but appears to be very helpful tool.
Does not work on Mac
eres una riata !! thanks