+ Reply to Thread
Results 1 to 6 of 6

saving file name based on value in predetermined cell

  1. #1
    jatman
    Guest

    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

  2. #2
    JB
    Guest

    Re: saving file name based on value in predetermined cell

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

    Cordialy JB


  3. #3
    Bob Phillips
    Guest

    Re: saving file name based on value in predetermined cell

    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




  4. #4
    jatman
    Guest

    Re: saving file name based on value in predetermined cell

    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

    >
    >
    >


  5. #5
    Bob Phillips
    Guest

    Re: saving file name based on value in predetermined cell

    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

    > >
    > >
    > >




  6. #6
    Forum Contributor
    Join Date
    03-14-2005
    Location
    Sweden
    MS-Off Ver
    Office 365
    Posts
    282
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1