The file was a real excel file. But the name didn't include the extension.

Much like if you renamed the file in windows explorer. You could still use
file|open to open that file and all your formulas, formatting, data would still
be there.



Susan wrote:

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

--

Dave Peterson