Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

A little help in programming docx to Excel

  1. Sep 22, 2016 #1
    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.

  2. jcsd
  3. Sep 22, 2016 #2
    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).
  4. Sep 22, 2016 #3
    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.
    I cant do anything else except writing inside the box and i only want to fetch the written data. So is it possible?


    Attached Files:

  5. Sep 23, 2016 #4
    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.
  6. Sep 26, 2016 #5
    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?
  7. Sep 26, 2016 #6
    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 (Text):
    Dim ofs As Office.FileSearch
    Dim i As Integer
    Set ofs = Application.FileSearch

    With ofs
        .FileType = msoFileTypeAllFiles
        .Filename = "*.doc"
        .LookIn = "C:\"
        .SearchSubFolders = True
    End With
  8. Sep 26, 2016 #7
    Thank you Pepper Mint. can you help me to fetch the datas written inside all the documents? I dont know much about programming.
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook

Have something to add?
Draft saved Draft deleted