1) PDF files have file names "[login to view URL]" "responses(1).pdf" "responses(2).pdf" etc. saved into a folder
2) PDF files will be configured to open with Microsoft Word as default application
3) Excel file (macro-enabled) to extract information from all the pdf files saved in the folder (e.g. 100 files in the folder should translate to 100 rows in the excel sheet) with a click of a button
4) Excel file should include other user-centric functions such as a button to select the folder
Background / Context / Potential Complications: The [login to view URL] files come from submission of an online form. There's certain logic built into the online form so the left hand column of the responses table may not always be the same. Have attached the online form, how it looks to users, how it looks backend and also the backend logic built in for better understanding.
I am open to other ways of extracting the data if Step 2 above is not the best way. Appreciate assistance from VBA expert out there to advice and do this project. I'm looking for someone who is responsive and open to discussions on best ways to do this. I am willing to change how some fields are named if it helps with the coding as well.
26 freelancers are bidding on average $162 for this job
Hi. I have written many automation Excel VBA macros also apps for formatting files including PDF, Excel. Can format any PDF files to any other templates. Ready to write your project. Will complete within 1 day
Hi there, Gone through your requirements and i clearly understood what you want. I am a Microsoft Certified Professional in Excel and VBA as an Expert. Awaiting your response to get started. Regards, Karthick G.
I can write js code to extract data from the pdfs to csv file, so you can open it in excel, please contact............................................................................
Hi there, I am an expert in excel formulas, dashboards, macros.I have gone through the description on your project and will be able to finish before the deadline. Thanks Arun
Hii My name is Sandeep Bhatt. i am doing your work in appropriate manner. if any correction is occure i will correct it in free on same day Thank You.