Quote Originally Posted by mdmackillop
[vba]If Chk = True Then
xlsWB1.Save
Else
xlsWB1.SaveAs ("C:\AAA\us1234.xls")
End If[/vba]
aah, didnt think about the flag! thanks much mdmackillop! it works like a champ!