Excel to Oracle connection using VBA for various oracle versions

[pam79]

Hi all,

I am posting this mail in hope to get some help on this forum as I have serached extensively on internet to find answer to this without much success.

I am connecting to Oracle Db from VBA. I have oracle driver in 'Oracle in OraHome92'. My connection works succefully but I need to send this file to multiple users and they may have different version of oracle and hence driver path may differ. How to handle this situation in VBA code?

Below is my code snippet:

Please Login or Register  to view this content.

Please help.

[pam79]

Anyone knows how to do this?