Use excel VBA to connected to oracle through a linked access table

I am trying to utilze excel vba to connect to a microsoft access database that is linked to oracle tables at work. I have been able to do this by saving my password in access for the oracle linked tables, but would like the ability to have the user enter the current password in the connection string. I have been struggling trying to find alternate solutions. Thanks in advance to whoever can help!