LinkBack URL
About LinkBacks
Is it possible to use a ADODB to do a SQL Query to a workbook with an Offset formula? Such as OFFSET(Named Range,0,1)
Is it possible to use a ADODB to do a SQL Query to a workbook with an Offset formula? Such as OFFSET(Named Range,0,1)
What would the purpose of the Offset be?
PS It's probably a good idea to change the thread title, Adodb isn't very descriptive.
If posting code please use code tags, see here.
The purpose would be is to ask SQL/ADODB to find the cell a certain row or column from a certain named range to find its value.
I don't quite follow, could you give an example?
So I would send a SQL Query that would state please find the value in the cell 2 Rows and 3 Columns away from Range("MyNamedRange"). Using named ranges helps it stay dynamic
Nicholas
That doesn't really sound like an SQL type of thing - what are you querying, what's the criteria?
If you wanted to get the value 2 rows down and 3 columns right then just use VBA's Offset.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks