PDF File scanning using VBA Excel Programming

Ever Wondered How to scan text/Data from a PDF file or document and make it useful or format able data?. No more you need to but a costly software to do this. Here is an easy way. You just need a Microsoft Excel.Wonder How follow these simple steps.

STEPS:
1)Keep cursor on the PDF Schematic.Press CTRL+A or click Select All option
(All the text data will be selected)

2) Copy the data from PDF Schematic

3) Paste it into an Excel Sheet column

4)Select the column (data pasted) and Click on sort A to Z

5)Go to Data in Menu bar and Click on Text to Columns option (A small window will be opened)

6)Click on Delimited -> Click Next ->Select Tab and Space in Delimiters list -> Click Next ->adjacent columns). 

Now you got the raw data. You can record or write  a macro/ VB script to work on this data and extract in the required form. Table / Paragraph, HTML etc..The VBA Example will be added in the following post.