A little help in programming docx to Excel

  • #1
38
1

Main Question or Discussion Point

Hello all,

i dont have much knowledge about programming so i googled about fetching datas from docx to excel and it showed can be done by VB. I see under developer tab in excel and opened Macros where i can write programmes.
Now i have many docx files in my folder and daily it is increased by one or two. I want my excel to fetch data from it automatically. Is it possible? If yes then how can i do it?
In the document i have names and numbers written. How can i do it? If not excel then access file is also good.
Kindly help.

Thanks,
 

Answers and Replies

  • #2
489
188
What format do the names and numbers have?
Are they tab separated, space separated, ...?

Another practical question, does this continue indefinitely? Because depending on the amount of names those files will become HUGE depending on the amount of records in each file and whether or not you delete them once your script runs. (caution is warranted because it could break when the format of the data changes resulting in a loss of data)
Depending on the number of records it would be good to look at other ways to store them than an excel file (e.g. a database).
 
  • #3
38
1
thank you so much for your reply,
I have a word that has only text box i believe in which i have to fill up data. Below is the screen shot
i dont know but i can't edit or click on any other written data except write inside box.
upload_2016-9-23_10-12-21.png

I cant do anything else except writing inside the box and i only want to fetch the written data. So is it possible?

Thanks,
 

Attachments

  • #4
489
188
Do you think this is what you want to do? http://www.techrepublic.com/blog/10...ransferring-word-form-data-to-an-excel-sheet/

It seems that it does what you want if(!) the form is filled locally. (You could call the macro they give at the moment they save although this might lead to double records)

In case you receive these forms daily I'll have to check out some more stuff.
A good idea could be to convert the forms to textfiles in a certain format (CSV, tab separated, ...) but I'm not immediately certain how this is done quickest/best.
 
  • Like
Likes Pepper Mint
  • #5
38
1
Thank you for replying. I have read the process but the problem is i have to open every document and program it. Instead is it possible to program a single excel file so that it can fetch all the data from documents available in the folder?
 
  • #6
87
138
Thank you for replying. I have read the process but the problem is i have to open every document and program it. Instead is it possible to program a single excel file so that it can fetch all the data from documents available in the folder?
Yes, definitely possible! you would have to write Subs or Functions to look up Word files in a specific directory then process each of them to get the output data.

For example, searching C drive for Word document files.
Code:
Dim ofs As Office.FileSearch
Dim i As Integer
Set ofs = Application.FileSearch

With ofs
    .NewSearch
    .FileType = msoFileTypeAllFiles
    .Filename = "*.doc"
    .LookIn = "C:\"
    .SearchSubFolders = True
    .Execute
End With
 
  • Like
Likes jmex
  • #7
38
1
Thank you Pepper Mint. can you help me to fetch the datas written inside all the documents? I dont know much about programming.
 

Related Threads on A little help in programming docx to Excel

  • Last Post
Replies
2
Views
2K
  • Last Post
Replies
18
Views
4K
  • Last Post
Replies
5
Views
3K
  • Last Post
Replies
1
Views
2K
  • Last Post
Replies
2
Views
3K
Replies
16
Views
969
Replies
4
Views
5K
  • Last Post
Replies
1
Views
2K
  • Last Post
Replies
8
Views
7K
  • Last Post
Replies
4
Views
2K
Top