I want to run this macro for different files. The problem is in the macro it
references the specific file I recorded it in. Is there a way to use this
macro for differnt files without actually going into the code each time? The
file name that will vary is "DRPT BCA Model 2009002.xls"

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 10/15/2008 by HDR
'

'
Windows("REF BCA - Final Model Template revised emissions.xls").Activate
Range("C12:AJ15").Select
Selection.Copy
Windows("DRPT BCA Model 2009002.xls").Activate
Range("C12").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Sheets("Raw Default Values").Select
ActiveWindow.SmallScroll Down:=-13
Range("E30").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = "0.05"
Range("E31").Select
End Sub