Save As

  • Thread starter Thread starter tc
  • Start date Start date
T

tc

hi. i have a worksheet which contains a name in a particular cell. is
it possible to create a macro that will use this name and save a copy
of the workbook with that name?
 
This doesn't specify a path unless that is in your cell with the
filename. But you can always add that into the code.
Sub foo()
ThisWorkbook.SaveAs Range("A1").Text
End Sub
 
Also, if you are storing your code in a separate workbook, you will
need to use ActiveWorkbook instead of ThisWorkbook.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Macro to use information in a cell to locate and send files using outlook 0
Adding ws information to cell in new wb & saving with ws name 7
Macro for all Excel Workbooks to print to PDF 2
Copying cells and formula from closed workbook to all sheets in open workbook 0
Strange behavior 3
Excel 2003 VBA In directory Open Spreadsheets Extract data 1
Buttons re-assigned themselves to the right macro name but in Book 1

Back
Top