Hi,

I recieve an excel file daily which has the date attached to the end of the
file name - ie Agent_SCCS12042007. How can I amend my script below to :
(1) have the macro open the file & import the data regardless of the date
information
(2) then delete this file from the d:drive

thanks!


ChDir "D:\UserData\userid\My Documents\Daily Telephony\new extracts to update"
Workbooks.Open Filename:="D:\UserData\userid\My Documents\Daily
Telephony\new extracts to update\Agent_SCCS"
ActiveWindow.SmallScroll ToRight:=10
Range("Q1").Select
Range(Selection, Selection.End(xlDown)).Select
Range("Q1:AC391").Select
Selection.Copy
Windows("Macro for scrubbing extract data.xls").Activate
Sheets("AGENT_SCCS").Select
Range("A2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Windows("Agent_SCCS.csv").Activate
ActiveWindow.Close