Exporting/Extracting HTML or PDF Tables into Excel

Hi All,

I just had a quick programming/general excel question surrounding my
current dilemma. Essentially, I am trying to extract financial tables
from SEC filings (either made in PDF or HTML). Ideally I would like to
have the capability of searching an SEC filing for a specific table
(i.e. lets say a "Consolidated Income Statement") and then have a macro
which would export that table into excel without losing the formatting.
If you guys have any idea as to how to go about doing this and
potentially provide me some starter code I would greatly appreciate
that.

Thanks

Mohammed

P.S. I know next to nothing about VB. So if you could explain what
parameters I may need it would be quite useful and what is going on
with the the code that would be helpful.

With the latest versions of Adobe Acrobat Reader, you can search for any text
string.

As for exporting tables into Excel, ScanSoft's PDF Converter 3 Professional
(retail: $100) actually allows you access into the PDF File, but be sure you
get the Professional version of PDF Converter 3.

However, before you buy any new software, you might just try highlighting
the text in the PDF file so you can copy and paste it into Excel. A lot of
people don't realize you can do this (you might need to download -- for free
-- the latest version of Adobe Acrobat Reader).



"[email protected]" wrote:

> Hi All,
>
> I just had a quick programming/general excel question surrounding my
> current dilemma. Essentially, I am trying to extract financial tables
> from SEC filings (either made in PDF or HTML). Ideally I would like to
> have the capability of searching an SEC filing for a specific table
> (i.e. lets say a "Consolidated Income Statement") and then have a macro
> which would export that table into excel without losing the formatting.
> If you guys have any idea as to how to go about doing this and
> potentially provide me some starter code I would greatly appreciate
> that.
>
> Thanks
>
> Mohammed
>
> P.S. I know next to nothing about VB. So if you could explain what
> parameters I may need it would be quite useful and what is going on
> with the the code that would be helpful.
>
>