Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel query object
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel query object
Anyone? Anyone? Bueller? Bueller?
"Bryan Dickerson" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel query object
Has anyone any ideas at all about this? I keep trying to write just a bit
of VBA behind this spreadsheet to pull data from a query and it keeps getting Application Defined Error '3704'. I think if I were able to access some query object and update that, it might work where what I'm doing now is not. Thanx! "Bryan Dickerson" wrote in message ... Anyone? Anyone? Bueller? Bueller? "Bryan Dickerson" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel query object
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |