Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm not new to VBA or VB, it's just been a while since I've done some VBA
behind Excel. I just need to add a bit of programming behind this spreadsheet. I need to prompt the user for 3 data items and then run an SQL stored procedure. I have created the spreadsheet and the datasource being the results of the stored query. So now, is there a VBA Excel object where I can get to (and modify) the SP call to insert the user's input for the 3 data items? I.e. I can press the button "Edit query" and see the "Exec <SPNAME 'Parm1', 'Parm2', 'Parm3', but can I get to it thru VBA and a worksheet object/property? TIA! Bryan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Does MS Query have an object model | Excel Programming |