Dave Peterson wrote:
How about just adding .xls to your string?

i thought that would just create a file name that tacked .xls
on the end, not influence the type of file.

But since you're using .SaveCopyAs, it'll always be an exact copy--including the
format of the file.

then why is the copy a file, not an .xls?
just wondering, will try the .xls add-on to filename.
thanks!
susan