Excel query object

  • Thread starter Thread starter Bryan Dickerson
  • Start date Start date
B

Bryan Dickerson

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
 
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!
 
If you're comfortable with SQL and querytables, you might be interested in
the Query Editor add-in available on my website.
 
I tried your query editor and man, you are a life saver!! Very cool! <Cue
the Wayne's World music> "I'm not worthy! I'm not worthy!!" I may just
abandon the VBA with this working as well as it does. Many gracious thanx!!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to pass parameters to excel from wscript (Windows script) 5
Stored Procedures - First Attempt 5
Trouble Installing Excel VBA Code Cleaner into Office 365 0
running a inut parameter query 1
Excel working with recording macro in excel 1
How to Pause an Excel VBA script without freezing excel 1
Option Private Module (for Object Modules) 5
Word Document Object on excel Sheet 8

Back
Top