![]() |
|
![]() |
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]() How can I export specific data fields from a job application form created in MS Word to a MS Excel spreadsheet please this will save me weeks as I am currently manually transferring all the data from hundreds of files Last edited by Charles Kenyon; 07-15-2016 at 08:30 AM. Reason: Mark as solved |
#2
|
|||
|
|||
![]()
See the following pages of Greg Maxey's website
http://gregmaxey.com/word_tip_pages/...rom_forms.html http://gregmaxey.com/word_tip_pages/...ment_file.html http://gregmaxey.com/word_tip_pages/...form_data.html |
#3
|
|||
|
|||
![]()
Thankyou I will see if the links help a quick question does the original word document have to be built in a special way or can data be extracted from any word document using the methods shown above
|
#4
|
|||
|
|||
![]()
I assume that as you mentioned that you wanted to "export specific data fields from a job application form" that the documents are in a format that allows the data that is to be exported to be identified. Exactly what do you mean by "data fields"? Are they one of the various types of controls that can be added to a Word document?
|
#5
|
|||
|
|||
![]()
The job application has been created using a simple word document with no drop downs or any identifiers for each section that needs completing example the applicants name is just first name with a box and surname with a box. Can I transform this document to capture these fields into an Excel spreadsheet or will I need to recreate the job application form using gvthe techniques highlighted in your first response
|
#6
|
|||
|
|||
![]()
Can you send me one of the documents so that I can see exactly from what it is that you want to extract the data. You should also let me know what data it is that is to be extracted. Send it to dkr[atsymbol]mvps[dot]org
|
#7
|
|||
|
|||
![]()
I will send it to you later today thankyou for your continued support on this matter
|
#8
|
|||
|
|||
![]()
I have sent across the document might be a large file as there are coloured logos on it
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Exporting quiz scores from powerpoint to excel spreadsheet/word | rjagile | PowerPoint | 1 | 02-08-2016 02:26 PM |
![]() |
Word4Dick | Word | 3 | 07-01-2015 09:57 PM |
![]() |
wingzero | Excel | 1 | 08-27-2014 06:12 AM |
![]() |
stagg201 | Excel | 1 | 03-27-2014 08:58 PM |
![]() |
jeffcoleky | Word VBA | 6 | 05-08-2012 08:24 AM |