Copying Data to a hidden Sheet

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")

You can use the ScreenUpdating property to hide your macro actions...From VB Help:

ScreenUpdating Property

True if screen updating is turned on. Read/write Boolean.

Remarks

Turn screen updating off to speed up your macro code. You won't be able to see what the macro is doing, but it will run faster.

Remember to set the ScreenUpdating property back to True when your macro ends.

Use it in your code like this:

Application.ScreenUpdating = False
'...your code goes here...
Application.ScreenUpdating = True

Hope this helps,
theDude