Hello everybody,

I created a macro which i am able to run in my pc which is
connected to a network, but when i save the excel file in the common drive
and try to open it from another machine, i am having trouble.what happens
actually is, i could open it, and run the macro, but it wont recognise bits
of coding. for eg:

Workbooks(energy).Sheets(energy).Range("A1:f1000") .Copy
ActiveSheet.Paste Destination:=Worksheets("Sheet1").Range("a1:f1000" )

where energy = "file name.xls", i know that this works only if the file that
i want to copy is kept open, and it works fine in my pc, and in some other
pcs that i tried. But it wont on majority of other machines in the network.
Please can anybody help??