-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
sqlquery
-
S
MACRO to extract data from HP ALM
We have the following code as a macro to extract data from the database of ALMQC. SQLquery = " SELECT " _ & " COALESCE ( " _ & " ( tsetfold10.CF_ITEM_NAME " _ & " + '\' + tsetfold9.CF_ITEM_NAME " _ & " + '\' + tsetfold8.CF_ITEM_NAME " _ & " + '\' +...- shre0047
- Thread
- join left sqlquery td.cycl_fold tsetfold1.cf_item_name
- Replies: 0
- Forum: Excel Questions
-
S
Remove hard-coding from macro/SQL
Currently, I have a macro report to pull tests from a database which is hard-coded and would like it so the end user can change the values on the tests in Sheet1 and the formula will change. Example: Sheet1: <tbody> Test #1 4846 Test #2 65489 Test #3 1289 </tbody> Within the macro...- shre0047
- Thread
- change sheet1 sqlquery t.ts_test_id test
- Replies: 3
- Forum: Excel Questions
-
S
Update the hard-coded line
I have a VBA to pull data from a database, but I am trying to not hard-code it. I am needing to pull a few tests from the database and currently running it, then changing the code to update the ids. Currently: SQLquery = SQLquery & " Where t.TS_TEST_ID = '39324' OR t.TS_TEST_ID = '39166' OR...- shre0047
- Thread
- database line sqlquery t.ts_test_id update
- Replies: 1
- Forum: Excel Questions
Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.
