Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-09-2018, 11:20 PM
dylansmith dylansmith is offline Automate Job application word doc to Excel (with data validation) Windows 8 Automate Job application word doc to Excel (with data validation) Office 2013
Optimizer
Automate Job application word doc to Excel (with data validation)
 
Join Date: Nov 2011
Posts: 118
dylansmith is on a distinguished road
Default Automate Job application word doc to Excel (with data validation)

how difficult is it to achieve and how reliable will the method be?



Most importantly, I'd also like to know how to validate data for various fields within Word (e.g. date of birth cannot be >70 years old, salary <$20,000, each employment period cannot overlap with one another for different roles), and then populate these fields in Excel for further analysis next time.

In addition (but off-topic), It will also be a bonus if there's a more secure method of storing sensitive information other than Google forms, especially for job applications (without resorting to enterprise-level solutions).

I look forward to hearing from you soon. Thanks!
Reply With Quote
  #2  
Old 02-11-2018, 12:58 PM
macropod's Avatar
macropod macropod is offline Automate Job application word doc to Excel (with data validation) Windows 7 64bit Automate Job application word doc to Excel (with data validation) Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,723
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Quote:
Originally Posted by dylansmith View Post
how difficult is it to achieve and how reliable will the method be?
How long is a piece of string? Are you trying to push that string end-wise uphill?

Really, you've told us nothing much that can be used for this. Getting the data out of Word depends on how well structured those documents are. Analysing the data in Excel requires that you set up the appropriate filters and that you've collected the relevant data in a way it is amenable to such analysis. Furthermore, Excel may not be the best tool; Access might be better suited.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automate Job application word doc to Excel (with data validation) Excel Data Validation Issue JTRothfmu11 Excel 1 08-12-2016 08:47 AM
How to automate many word and excel files at once pythonturq Office 1 10-16-2015 06:00 PM
Data validation using conditional parameters in Excel table dougdrex Excel 2 01-06-2015 07:44 AM
Data Validation Issue in Excel rrparekh Excel 0 10-27-2014 10:53 AM
Automate Data from Excel into Word DropDown...? sigraves Word VBA 0 08-03-2009 06:54 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 12:53 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft