Excel 2007 :: Connecting To Oracle Database By IP

I am running Excel 2007 and connecting to an Oracle DB.

I have created a VBA macro to connect to an oracle DB and retrieve data then place it in a table. The code works, but it uses DSN entries which are specific to my computer. I want to be able to distribute this Excel spreadsheet to others in my company and have them be able to click one button and update the data. I figure the most logical way is to connect to the DB using an IP address that should work for anyone on the intranet.

How do I modify the connection info below to have it connect via IP?

I tried "Data Source = 10.1.1.10orcl" and "Data Source = 10.1.1.10", both of which VBA dislikes.

Here is what I have now:

Code:
Sub Create()
Dim Servername As Range
Set Servername = ActiveWorkbook.Sheets("Summary").Range("B16")

Set StartDate = ActiveWorkbook.Sheets("Summary").Range("B3")

[Code] ..........