saving file name based on value in predetermined cell

how do i save a file based on a predetermined value in a cell.

ex. the value in cell B11 contains a date. i want that date to be the file
name that it gets saved as.

regards,

jat jaswal

ActiveWorkbook.SaveAs Filename:=Format([b11], "yyyy_mm_dd")

Cordialy JB

You have to be careful not to use \ in a filename, so you cannot use the
cell Text property. Format the date yourself, in reverse order for sorting

Activeworkbook.SaveAs Filename:=Format(Range("B11").Value,"yyyymmdd")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"jatman" <jatman@discussions.microsoft.com> wrote in message
news:E561BC9E-958E-469A-AAA8-3F91BC4ED586@microsoft.com...
> how do i save a file based on a predetermined value in a cell.
>
> ex. the value in cell B11 contains a date. i want that date to be the
file
> name that it gets saved as.
>
> regards,
>
> jat jaswal

JB/BOB:
thanx for the reply, but when i right click on the tab, view code, i cut and
paste the line code into the file and i get an error. the only change i had
to make was to match the cell properly H3:J3 (merged cells) and the date
format is dd mmm yyyy (already formated in cell) but i changed the date
format in the code to both suggestions.

i only have a few selections in the workbook for where i can enter the code.
i'm entering the line in the BeforeSave because i do not see SaveAs Filename
anywhere for options.

any other suggestions?

regards

jat jaswal

"Bob Phillips" wrote:

> You have to be careful not to use \ in a filename, so you cannot use the
> cell Text property. Format the date yourself, in reverse order for sorting
>
> Activeworkbook.SaveAs Filename:=Format(Range("B11").Value,"yyyymmdd")
>
> --
>
> HTH
>
> Bob Phillips
>
> (remove nothere from the email address if mailing direct)
>
> "jatman" <jatman@discussions.microsoft.com> wrote in message
> news:E561BC9E-958E-469A-AAA8-3F91BC4ED586@microsoft.com...
> > how do i save a file based on a predetermined value in a cell.
> >
> > ex. the value in cell B11 contains a date. i want that date to be the
> file
> > name that it gets saved as.
> >
> > regards,
> >
> > jat jaswal
>
>
>

Not sure about the merged cell, but you seem to be adding the code to the
worksheet code module. Why there? I would have expected it as a macro, or
maybe embedded in BeforeSave event and test for SaveAs.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"jatman" <jatman@discussions.microsoft.com> wrote in message
news:37A577EC-77E7-4537-9144-9B1DEF5D22D4@microsoft.com...
> JB/BOB:
> thanx for the reply, but when i right click on the tab, view code, i cut
and
> paste the line code into the file and i get an error. the only change i
had
> to make was to match the cell properly H3:J3 (merged cells) and the date
> format is dd mmm yyyy (already formated in cell) but i changed the date
> format in the code to both suggestions.
>
> i only have a few selections in the workbook for where i can enter the
code.
> i'm entering the line in the BeforeSave because i do not see SaveAs
Filename
> anywhere for options.
>
> any other suggestions?
>
> regards
>
> jat jaswal
>
> "Bob Phillips" wrote:
>
> > You have to be careful not to use \ in a filename, so you cannot use the
> > cell Text property. Format the date yourself, in reverse order for
sorting
> >
> > Activeworkbook.SaveAs Filename:=Format(Range("B11").Value,"yyyymmdd")
> >
> > --
> >
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from the email address if mailing direct)
> >
> > "jatman" <jatman@discussions.microsoft.com> wrote in message
> > news:E561BC9E-958E-469A-AAA8-3F91BC4ED586@microsoft.com...
> > > how do i save a file based on a predetermined value in a cell.
> > >
> > > ex. the value in cell B11 contains a date. i want that date to be
the
> > file
> > > name that it gets saved as.
> > >
> > > regards,
> > >
> > > jat jaswal
> >
> >
> >

Hello.

I need a macro that copies a range to a new workbook and saves the new workbook with a predefined name.
The predefined name should be like "name current date.xls".
I know how to create the first steps but I don't know how to use the predefined name.

I saw this question and it might be a good place to ask this question or am I wrong?

Please help.

/Anders