This is called from vbyesno
ActiveWorkbook.SaveAs Filename:="A:\LoadingSupplies.xls", FileFormat _
:=xlXLS, CreateBackup:=False
Useing this from a userform click event trying to have user chose location
then do it auto.
I am missing something
Thanks