Excel 2007 VBA code help for copying data from a SQL server file

[dangerousdaveeg]

What I am having trouble with is that I have a SQL server report that gets generated every day and placed in a set location.

My report has some macros to delete the last set of data copied and then update it with the fresh set of data, However though even when I move the SQL server report so that the next one will generate and takes it place when i run my macro I am still pulling the data from the previous report and not the new one that has been generated.

anyone got any ideas what might be going wrong?

Here is the code I am using

Sub Delete()
'
' Delete Macro
'

'
Range("B2:F130").Select
Selection.ClearContents
ActiveWindow.SmallScroll Down:=-126
Workbooks.Open Filename:= _
"P:\membership services\operations\Automated Reports\Agent Daily Summary.xls"
ActiveWindow.SmallScroll Down:=-12
Range("C5:G130").Select
Selection.Copy
Windows("Daily Stats Master.xlsm").Activate
ActiveWindow.SmallScroll Down:=-9
Range("B2").Select
ActiveSheet.Paste
End Sub


Any help will be much appreciated as I just cant seem to figure out why it does not look at the new file, the SQL server reports are always called the same thing but once used they are moved to a new location and called something different.