shg:

Many thanks for your input. The code line ran fine in 2003 but failed/stopped in 2007.

Seems you are correct, the addition of the file extension, in my case .xlsm allowed the code to work in 2007 similiar to 2003.

While you say it's not a 2007 issue, I have to say that it appears 2007 requires file extensions and in earlier versions the extension is not mandatory.

Thanks for you help. It made all the difference.

Cliff