Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. RODEOSOLSTICE

    VBS to change query in CommandText Property

    Thanks strongm, I will bookmark, and if a moderator wants to move this thread, have at it. I will enjoy knowing the vbs section is there, I couldn't find it when I joined up
  2. RODEOSOLSTICE

    VBS to change query in CommandText Property

    Skip, YOU DA' MAN.. that's it, got it to work!!! Need to modify some for my needs, but 100% absolutely what I need!!! I owe ya a cold one, I've been chasing down this need for a long time, and now our projects will be that much easier!!!! Thanks you very much, Greg :)
  3. RODEOSOLSTICE

    VBS to change query in CommandText Property

    Much obliged Skip, very much. I couldn't find any way to send a personal message, so wanted to be sure to say thanks. I'll toy with that, it looks very promising!
  4. RODEOSOLSTICE

    VBS to change query in CommandText Property

    That'd be great. Not sure I could pull it off, any chance you combine it as an example? I should add my script is a .vbs script
  5. RODEOSOLSTICE

    VBS to change query in CommandText Property

    I'm going to give that a try. I was hoping to alter the querytable query from an external script, much like I do to refresh and export the PDF. But, I could rethink to perhaps use the concept you proposed above. Thanks very much, this one is a requirement for our projects.
  6. RODEOSOLSTICE

    VBS to change query in CommandText Property

    worksheet name = Sheet1 And just the one querytable per workbook. Thanks much for the help.
  7. RODEOSOLSTICE

    VBS to change query in CommandText Property

    Excel 2013. Maybe I should try another way... I have a XLSX file named 4332_TX.xlsx with this query: SELECT ID, STATE, COUNTS FROM Database.dbo.Table1 where ID = 4332 and STATE = 'TX' and COUNTS > 0 I want to make a copy of that file (batch or python script to copy file), name that copy...
  8. RODEOSOLSTICE

    VBS to change query in CommandText Property

    I use XLSX files to pull data from SQL, and format for PDFs. What I need is to update the query that is in the CommandText The query is like this: SELECT ID, STATE, COUNTS FROM Database.dbo.Table1 where ID = 4332 and STATE = 'TX' and COUNTS > 0 I need VBS to change this query on attributes...

Part and Inventory Search

Back
Top