The easiest way is to open the file and then grab the data:


Sub Macro1()
Workbooks.Open Filename:="N:\remote.xls"
Windows("remote.xls").Activate
Range("A83").Select
Selection.Copy
Windows("Book1").Activate
ActiveSheet.Paste
End Sub

--
Gary''s Student


"Rob Moore" wrote:

I am working on an excel macro and I need to copy data from another excel
file on a shared network drive. Any suggestions on code needed to copy a
cell from a different file and paste in my file?

Thanks