a challenge for a VBA guru
 

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?

a challenge for a VBA guru
 

Hi Dave

Try this
http://www.rondebruin.nl/copy7.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Dave F" wrote in message ...
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?