Also I need to loop this against potentially 3k in airbills and have the data
reside beside the airbills in columns to the right

"ron" wrote:

On Sep 5, 4:49 pm, TXDalessandros
wrote:
It may be internal....Can you do this based on another webpage...
the basis is to access a webpage based on a list and then search a field
based on that and extract either the whole page or certain fields

No, I need to see the source code behind the specific webpage in order
to see how to submit an airbill number. However, if you can figure
that part out, then you can use

ie.ExecWB OLECMDID_SELECTALL, OLECMDEXECOPT_DONTPROMPTUSER
ie.ExecWB OLECMDID_COPY, OLECMDEXECOPT_DODEFAULT

ActiveSheet.PasteSpecial Format:="Text", Link:=False,
DisplayAsIcon:=False
Range("A1").Select

to select, copy and paste to A1 of the activesheet, all of the webpage
that is in the webpage opened by your macro...Ron