Establishing a connection with HPSM9 through Excel Macros

Hi,

Can anyone please guide me in establishing a connection with SM9 through excel macros.

Thanks in advance.