Excelnoobisme
Board Regular
- Joined
- Nov 19, 2010
- Messages
- 128
i have excel's add-in of ibm showcase query and have also setup the query reference.
below is my code,
i = Application.Run("ScRefreshQuery", "C:\Program files\GP.DBQ")
this will help me open the query and have to key in my criteria, the query will automatically export to the excel according to the query reference.
I have 2 questions,
1)what i need to do to bypass typing the username and password when the showcase query open up.
2)is there any way i can link the criteria to enter in query to 1 of the cell in the excel file?
below is my code,
i = Application.Run("ScRefreshQuery", "C:\Program files\GP.DBQ")
this will help me open the query and have to key in my criteria, the query will automatically export to the excel according to the query reference.
I have 2 questions,
1)what i need to do to bypass typing the username and password when the showcase query open up.
2)is there any way i can link the criteria to enter in query to 1 of the cell in the excel file?
