No it did not. It was hanging before the save as. I finally got it to work.
If I do just a Temp.Copy without the Befo=ActiveWorkbook.Sheets(1), then
it runs
"Ron de Bruin" wrote:

Is the code on my site working for you ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"C2Ranches" wrote in message ...
Thank you for your fast response I will give it a try

"C2Ranches" wrote:

Does anyone know why this code would work in Excel 2007 as long as it is
saved in 2003 format, but if it is saved in Excel 2007 format it will work
once but not twice or mo

Workbooks.Add
Temp.Copy Befo=ActiveWorkbook.Sheets(1)
Application.CutCopyMode = False
ActiveWorkbook.SaveAs Filename:="C:\HOLDINGS\stipdaily"
ActiveWorkbook.Close
Book.Close


Runs the first time fine, but if you try to run it again, it hangs at:
Temp.Copy Befo=ActiveWorkbook.Sheets(1)
If you save the Macro in 2003 format, it works every time you want to run it.

Thanks ahead of time for any clues you can pass along.