I don't know another way to deal with the overwrite warning if the file I
want to save already exists. savecopyas seems to be the easiest way. in
either case, that shouldn't have an impact on whether the current sheet is
save or the whole workbook, right?

smokii

Dave Peterson wrote in
:

Without trying to recreate your code from the snippet you posted, why
not just use:

.saveas
(instead of .savecopyas)

Inside VBA's help, you'll see all the parms you can pass (including
fileformat).

.savecopyas will keep the original workbook open with that name, but
since you're closing the workbook right after, it doesn't look like
that would matter.