Excel Add-In Login (version 9.1)

Hi Community,

Did anyone have successfully used VBA to connect via Excel macro?

I had tried all of the connection code from the link below without success;
Visual Basic for Applications (VBA) Procedures

Regards,
Seang