Here's the situation:

The company I work for has an Excel document on its intranet. I want to
write a macro that will (1) access this document (whose URL is static), (2)
copy the value in cell B36 (this cell location is static as well), (3) and
paste it into a new spreadsheet.

My guess is this code is relatively straightforward but I can't get my head
around what would be required to access the document on the intranet.

Any ideas?