Macro for PDF to Excel conversion

[David McCue]

I receive a daily email with a PDF report in it and I want to convert it to Excel so that I can do some sorting etc. as it has lots of info on it that is not used. Would someone be kind enough to assist with some code to be able to do this in a macro that I can add to my sheet

The pdf will be called POP01Dec18 with the date changing each day

 

[oldbrewer]

are you able to manually copy the pdf into excel ?

 

[David McCue]

are you able to manually copy the pdf into excel ?

Yes but this is the 1st step in a bigger macro that I want to set up.

I am trying to reduce the steps involved for other users and because after I get the pdf info into my spreadsheet I want to do some sorting with it by removing the excess info and then copying that into another tabbed page.

 

[oldbrewer]

ok so turn on record macro , copy the pdf, paste into excel, stop the recorder. The code will be your starter...

 

[David McCue]

This copies it across just as text without the columns being recognised or seperated as there are no seperators in the pdf

<colgroup><col style="width:48pt" width="64" span="7"> </colgroup><tbody>
[TD="colspan: 2"][/TD]

[TD="class: xl8740"][/TD]

[TD="class: xl8740"][/TD]

[TD="class: xl8740"][/TD]

[TD="class: xl8740"][/TD]

[TD="class: xl8740"][/TD]

[TD="class: xl8740"][/TD]

[TD="colspan: 3"][/TD]
[TD="class: xl8740"][/TD]

[TD="class: xl8740"][/TD]

[TD="colspan: 3"][/TD]
[TD="class: xl8740"][/TD]

[TD="class: xl8740"][/TD]

[TD="colspan: 3"][/TD]
[TD="class: xl8740"][/TD]

[TD="class: xl8740"][/TD]

[TD="class: xl8740"][/TD]

[TD="class: xl8740"][/TD]

[TD="class: xl8740"][/TD]

[TD="colspan: 3"][/TD]
[TD="class: xl8740"][/TD]

[TD="colspan: 3"][/TD]
[TD="class: xl8740"][/TD]

[TD="colspan: 3"][/TD]
[TD="class: xl8740"][/TD]

[TD="colspan: 3"][/TD]
[TD="class: xl8740"][/TD]

</tbody>

 

[David McCue]

When I do this it does not format it into columns

 

[oldbrewer]

there is a free pdf to word converter on line........

 

[David McCue]

I have seen the free converters but I want a macro to do it for me and I want it in excel version. Can someone please assist with this

 

[oldbrewer]

I think then you will need adobe writer...