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
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 :)
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!
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.
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.