PDF to Excel and Format - Rent Roll Related

[PeakSquare]

Our rent roll is in pdf file. I converted to excel file, but it gave me 38 pages. also, the rent amount is not lined up with the renter's name (it was a different charge that lined up with the name). What's the best way to parse the data to extract the rent roll info?

 

[Logit]

Here is a PDF to Excel Converter. Once you've converted the file, then you can parse it out as required.

Download file : Internxt Drive – Private & Secure Cloud Storage

 

[PeakSquare]

thanks so much Logit. but it can't find the pdf folder. not sure why. I double checked many times. the path looks right.

 

[Logit]

My research has shown that most all VBA versions of Convert PDF To Excel require Adobe Acrobat as well. I see the file I sent you says nothing about Adobe nor does
the code utilized Adobe. My apologies.

 

[PeakSquare]

My research has shown that most all VBA versions of Convert PDF To Excel require Adobe Acrobat as well. I see the file I sent you says nothing about Adobe nor does
the code utilized Adobe. My apologies.

no worries. thanks for chiming n.