Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract MS Query Cell Address
When I Import Data (MS Query) into my spreadsheet is asks for destination
cell. Is it possible to extract this cell address from the MS Query object after-the-fact? Thanks EM |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract MS Query Cell Address
The querry Name and Range becomes a defined Name on the worksheet. You can
view the range on the worksheet by going to menu and doing the following File - Properties - Contents Use this VBA code to see all names including querry name For Each myname In ThisWorkbook.Names MsgBox (myname.Name & " Range is : " & myname) Next myname: When I Import Data (MS Query) into my spreadsheet is asks for destination cell. Is it possible to extract this cell address from the MS Query object after-the-fact? Thanks EM |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract MS Query Cell Address
This almost gets me there but I will need a way to differentiate between the
named cells. Don't think there is a way to do that. EM "Joel" wrote: The querry Name and Range becomes a defined Name on the worksheet. You can view the range on the worksheet by going to menu and doing the following File - Properties - Contents Use this VBA code to see all names including querry name For Each myname In ThisWorkbook.Names MsgBox (myname.Name & " Range is : " & myname) Next myname: When I Import Data (MS Query) into my spreadsheet is asks for destination cell. Is it possible to extract this cell address from the MS Query object after-the-fact? Thanks EM |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract MS Query Cell Address
Dim rng as range
set rng = ActiveSheet.QueryTables(1).ResultRange msgbox rng.Cells(1, 1).Address -- Tim Zych SF, CA "ExcelMonkey" wrote in message ... When I Import Data (MS Query) into my spreadsheet is asks for destination cell. Is it possible to extract this cell address from the MS Query object after-the-fact? Thanks EM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I extract a string from an IP address in Excel? | Excel Discussion (Misc queries) | |||
Extract address data | Excel Worksheet Functions | |||
How to extract email address in hyperlink | Excel Worksheet Functions | |||
How to extract a web address from a hyperlink cell? | Excel Discussion (Misc queries) | |||
How do I extract the address from a hyperlink in excell ? | Excel Discussion (Misc queries) |