Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a 'GetKeys' or equivalent?
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a 'GetKeys' or equivalent?
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a 'GetKeys' or equivalent?
Thanks for that!
I'm not sure I can go ahead and write a routine with Get= External Data and ADO. One or 2 examples would be much appreciated and may help clarify how I could proceed. Also with web queries to extract data from a web page table. Many thanks "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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a 'GetKeys' or equivalent?
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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a 'GetKeys' or equivalent?
I didn't say do both
for ADO http://tinyurl.com/8ctp7 for get external data, turn on the macro recorder while you do it manually. -- Regards, Tom Ogilvy "Zakynthos" wrote in message ... Thanks for that! I'm not sure I can go ahead and write a routine with Get= External Data and ADO. One or 2 examples would be much appreciated and may help clarify how I could proceed. Also with web queries to extract data from a web page table. Many thanks "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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EQUIVALENT for this FORMULA , please | Excel Worksheet Functions | |||
Equivalent of Alt+Tab for going between worksheets? | Excel Discussion (Misc queries) | |||
Equivalent Of VAL | Excel Programming | |||
Lotus Equivalent | Excel Discussion (Misc queries) | |||
VBA equivalent of findstr | Excel Programming |