Instead of configuring an ODBC connection on the Machine tab try configuring
an ODBC connection on the User tab.

If you are using Oracle integrated security, then the username is a
forward-slash.

While experimenting, you may find my Query Editor add-in useful - available
on my website.

--
Rob van Gelder - http://www.vangelder.co.nz/


"kuh" wrote in message
...

Please help me. I have many query table using data source : ODBC and
driver : Oracle. I want to refresh the table using own password for
each username. How to add my macro for doing that?
It's my macro :

Code:
--------------------
Sub refresh1()
With Sheets("Data").Range("B5")
.QueryTable.Refresh BackgroundQuery:=False
End With
End Sub
--------------------


thanks very much.


--
kuh
------------------------------------------------------------------------
kuh's Profile:
http://www.excelforum.com/member.php...o&userid=31224
View this thread: http://www.excelforum.com/showthread...hreadid=508948