Save As

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tc - 18 Sep 2007 16:37 GMT

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?

Reply to this Message

JW - 18 Sep 2007 16:42 GMT

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

> 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?

Reply to this Message

JW - 18 Sep 2007 16:43 GMT

Also, if you are storing your code in a separate workbook, you will
need to use ActiveWorkbook instead of ThisWorkbook.

> This doesn't specify a path unless that is in your cell with the
> filename. But you can always add that into the code.
[quoted text clipped - 4 lines]
> > it possible to create a macro that will use this name and save a copy
> > of the workbook with that name?

Reply to this Message