Hi,

I need to copy data to a sheet that is hidden. eg the user doesnt see the copy process. Can someone help me out... (It is C:\Dump that needs to be hidden) Cheers.

Workbooks.Open Filename:="C:\Dump.xls"
Rows("2:75").Select
Range("B2").Activate
Selection.Delete Shift:=xlUp
Windows("25-10-04.xls").Activate
Selection.Copy
Windows("Dump.xls").Activate
Windows("25-10-04.xls").Activate
Selection.Copy
Windows("Dump.xls").Activate
Rows("2:2").Select
Range("B2").Activate
ActiveSheet.Paste
Application.CutCopyMode = False
ActiveWorkbook.Save
ActiveWindow.Close
MsgBox ("Completed Copying")