How to copy all PDF Contents to Excel within a Browser

[drmingle]

I am attempting to pull down the contents of a particular PDF and I don't want to have to manually launch the URL, select all, copy all, open my excel file, and paste all.

Any help would be appreciated...

Below is the non-working code I have so far:

Sub Read_PDF()
'References: Adobe Acrobat 9.0 Type Library
'References: Adobe Acrobat Browser Control Type Library 1.0
'Objective: To pull All PDF contents into active Excel sheet

Dim myobj As New Acrobat.AcroApp

'PDF that I want the contents of...
myobj = "http://abespa.org/files/roster.pdf"
myobj.Show
'Believe this will help pull the contents of the PDF
myobj.GetActiveDoc

'Believe this will help paste the contents of the PDF to my active Excel sheet
ActiveWorkbook.Select
Range("A1").Select
ActiveSheet.PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:= _
    False
    
End Sub