Excel file save macro.

  • Thread starter Thread starter darrenlshipley
  • Start date Start date
D

darrenlshipley

I need help with a macro. I want to be able to save a file as a listed
name, that is referenced in a cell, in a directory that is listed in a
different cell.
 
Try this:

ActiveWorkbook.SaveAs Filename:=Range("A1")

A1 would be the cell with the desired file name.
If desired, A1 can contain a specific directory to save the file. (ex -
C:\Windows\filename.xls)
 
Back
Top