Agree, couple of examples would be helpful.

"Tom Ogilvy" wrote:

Get=External Data

if you have ODBC driver for Oracle.

In code you can use ADO.

for a web, if it is a table, you can do a web query also at Get=External
Data.

--
Regards,
Tom Ogilvy

"Zakynthos" wrote in message
...
I am fairly proficient in using SendKeys but would like to know if there
is
an equivalent 'GetKeys' to enable me to:

(a) extract data from an Oracle-based database which although in
'spreadsheet format' does not have cell references like A1 etc, and
import/send to Excel

(b)extract data in Tables from a company intranet page into Excel.

Are either/both of these 2 processes possible?