I have the fully qualified filename stored in a string called fname. When I execute the VBA code:
For Each sh In ActiveWorkbook.Worksheets
If sh.Name = "Claims_Detail" Then
ActiveWorksheet.SaveAs Filename:=Fname, FileFormat:=51
a SaveAs box pops up with book1.xlsx as the name of the file to be saved. My goal was to have no popup and save it in the path and file defined in fname.
What am I missing?
ActiveWorksheet.SaveAs should be ActiveWorkbook.SaveAs.
Open in new window