This is the code for my macro:

Windows("dump.xls").Activate
Cells.Replace What:="$", Replacement:="", LookAt:=xlPart
SearchOrder:= _
xlByRows, MatchCase:=False
Cells.Select
ActiveWindow.Zoom = 75
Columns("A:A").Select
Selection.Copy
Windows("New_format_PL_101103_test.xls").Activate
Range("A1").Select
ActiveSheet.Paste
Windows("dump.xls").Activate
Columns("B:D").Select
Application.CutCopyMode = False
Selection.Copy
Windows("New_format_PL_101103_test.xls").Activate
Range("C1").Select
ActiveSheet.Paste
Windows("dump.xls").Activate

As you can see, it copies information from one page and pastes it int
another. my problem is, how can I replicate this macro without havin
the names of the files in there. I plan to make a new document b
copying new_format_pl_101103.xls everyday, and renaming it, so today
this document is called new_format_pl_111103.xls. I don't want to hav
to go into the code everyday so that my macro can be run.

Please help me. Thanks

Sheeta

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com