macro to save as a data input by user file name from a designated

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a macro that will save the workbook prior to deleting all specified
cells but I'm trying to make it save as file name of what ever the user
inputed into a specified cell or cells like the date that they input and
another cell that they inputfor like name of etc.....
 
Maybe this will give you a start:

with thisworkbook
.saveas filename:=.worksheets("sheet1").range("a1").value & "\" _
& .worksheets("sheet999").range("b999").value & "\" _
& format(worksheets("sheet1000").range("d323"), "yyyymmdd") _
& "somemoretext here" & ".xls"
end with
 
Brian said:
I have a macro that will save the workbook prior to deleting all specified
cells but I'm trying to make it save as file name of what ever the user
inputed into a specified cell or cells like the date that they input and
another cell that they inputfor like name of etc.....
Click to expand...
 
Back
Top