I should of tested the change better. Still ended up with two XLS at the end
of the file. One problem is using the TMP directory your original workbook
is opened and puts the open file into the Tmp directory. I put a Z infront
of the temporay filename because I got an error that I was saving a file to a
filename that already existed (the open file).

Make this change to my last posting and it will work. guarenteeed.

from
FName = TempFilePath & TempFileName & ".xls"
to
FName = TempFilePath & "z" & TempFileName


Note: TempFilename has the XLS on the end already.

"andiam24" wrote:

Joel, you're fast! Copied and pasted the code but still getting code in my
sent attachment. Very frustrating :(