Copying a Word Document to Excel Manually can be tricky

On a recent gig I ran into a problem where my PDF converter would not handle (straight to Excel) the PDF created by a Mac

But the converter could put the PDF file into Word - well, I then tried to copy paste it manually - and after several attempts finally succeeded, but it was tricky. I got a picture of the first page pasted several times, and - It was on a gig, so I wanted to automate

Well, I looked at the Word forum and found some code by macropod (Bless him/her), so plagiarizing from macropod and using the recorder, I came up with this routine:

Please Login or Register  to view this content.

And - it seems to be pretty slick!

Hi Accede,

I tried that, but, for me, this method gave better results - in either case, I had to write a formatting routine but the one with the copy-paste above was simpler. The PDF I had was created on a Mac, so that may have had something to do with it.