| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Location of SQL in an external data connection
I have a range that is populated with data from SQL Server when I invoke the
ActiveWorkbook.RefreshAll method in code. Now I want to modify the SQL behind the query, but I can't see how to expose it in my Excel 2007 worksheet. (I'm sure this was easy in 2003, but seems to be hidden by 2007's Ribbon of Confusion.) Thanks, Al |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2010 (64 bit) External Data connection with Access | Excel Discussion (Misc queries) | |||
| External data connection needs separate login for each query | Excel Discussion (Misc queries) | |||
| Problem getting external data using an existing connection | Excel Discussion (Misc queries) | |||
| Connection to external data sources in Excel | Excel Discussion (Misc queries) | |||
| Problem: Residual query data? Closing external connection? | Excel Programming | |||
Threaded Mode
