Search results for query: *

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!

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

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.

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

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...