Thread: macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default macro

Sub ordinate()
varFname = Application.GetSaveAsFilename(ThisWorkbook.Name, _
"Excel Files (*.xls),*.xls")
ActiveWorkbook.SaveAs Filename:=varFname
End Sub

--
Gary''s Student - gsnu200750