Converting PDF to Excel issue (automation)

First a big thank you to help provided to me a ways back on using visual basic to tackle data spillover issues while trying to convert a .pdf file into an Excel file. I am pushing my limits of using visual basic and have been trying to figure out a way to run two scripts together (one after the other).

My goal is to simplify the number of times a user has to copy/paste code or touch the data. The .pdf comes out as one worksheet for each .pdf page. I am using a combine script to make one big worksheet.

Data spills down over several rows in a column during the conversion and I needed each property item on one row each. Thankfully someone way smarter than me provided that script. Though for some weird reason the top 10-20 rows does not recognize that script.

I am trying to figure out a way that someone can save the .pdf as an .xls and by clicking one button (minimizing issues) a script will combine everything onto one sheet and then combine any spill over so that each piece of property information runs across it's own row. The script would then auto sort by column A and maybe even auto delete all rows that do not contain numbers in column A, leaving only property on the sheet. If it then deleted any column A duplicates it would make life much easier for a lot of people!

I have attached an edited version of a how to guide to describe the process- it includes the scripts mentioned above and shows to be a bit cumbersome.


Any guidance or help as always appreciated...

D