Re: SAP Connection - Which References
The reason why they are not listed is because they are not in Excels object paths.
Move them to where Excel expects them to be and things will work fine.
It sounds as you're just starting out with OLE, so if you like, Here is a thread which contains an excel function returning an SAP object and an example of how to use VBA to call an SAP RFC enabled function.
If you want any further help with things like the Table Factory etc post your questions to this thread and I'll pick them up.
<shameless plug.....>Have a look at the Abappers Knowledge Corner on http://www.sapsuperusers.com (and SSU in general). For genereal questions rather than documentation etc, http://www.sapfans.com is the one and only.