Accessing a Remote Server

Good morning --

I am developing a workbook to be used by medical groups to assess their
performance. The workbook wants to pull reference information from a
workbook stored centrally on a remote server on the Web. The server is
password-protected. I'd like to write a line that connects to the server, so
that my next lines can open the workbook and extract information to load into
the cells. (I need to update the info because the reference data varies by
MD specialty, and changes over time.)

So -- if the server I'm trying to access might be:

name: Library.google.com
Login: MedicalGroup
Password: Physician

What's the code I use to get there? (Incidentally, the workbook from which
reference data will be extracted might be "Instrument Panel Reference Data",
and the password for it might be "GetIn".

Thanks in advance.