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?