I need to copy and summarize certain data from excel sheets on various
machines in a network to an excel sheet on my computer in the network. how
can I possibly do it???

hi,

as long you can enter the network, you can do this:
sub openwbooknw()
dim Path
Path = "\\ZW\PUBLIC\"
workbooks.open Path & "bookname.xls"
'''' code to retrieve data here....

end sub
--
Regards,

Halim



"Kanhaiya" wrote:

I need to copy and summarize certain data from excel sheets on various
machines in a network to an excel sheet on my computer in the network. how
can I possibly do it???