Log into specific transaction in SAP from Excel

I need to provide a logon box for SAP and then call a specific transaction from an Excel macro. I've found some of the answers here, but not enough to submit code for your analysis.

Would someone please point me in the right direction.

Thanks

Bob