Rory,
I followed your suggestion, I removed the .name after wbkName, it does not hang up on the object required, but does now try to rename the sheet the entire path name:
"C:\Documents and Settings\Doug\Desktop\ForEach\Book1.xls"
I am still of the opinion I need to get the filename from the variable.
But there may be some error in my understanding of that. But Xld said it ran for him. So-- maybe it is something else I do not see.