import data from PDF into excel sheet with the same structure

[Hasson]

hello

I put this link VBA Express : Excel - get the data from PDF file into Excel sheet(s) or text file(s) you can see the code . I don't attach code because is too big.

so the code import all of data from file pdf into one column A into sheet excel . I search for way if it's possible I have the data into table for about 4 or 5... columns from pdf file should import with the same structure into excel sheet in columns A,B,C,D.... and the same thing with separated cells instead of into one column A . like the same thing as in import specific sheet from file to another . I hope my question is logic as for VBA
thanks

 

[Hasson]

I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.

I agree with you , but some cases PQ is useless with complicated cases then it needs VBA . in my case I search like the video but unfortunatly is not available in my version 2016,2019 so in this case needs vba