Referring to a cell in a spreadsheet on a networked computer

I'm new to VBA and just learning. I need to refer to a cell in a spreadsheet on a networked computer and I just can't seem to get the syntax correct. Any help is greatly appreciated.

Show how you have tried to do it.

Artik

got this one solved. thanks