MS Excell Beginer

Please give me the code to write a macro in Excell i.e in Visual Basic Editor to get connection to oracle with out using ODBC.
please give the code.
I shall be much thankful to you