+ Reply to Thread
Results 1 to 6 of 6

How to Save as a file with current date and specific text as file name

  1. #1
    Forum Contributor prabhuduraraj09's Avatar
    Join Date
    05-19-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    330

    How to Save as a file with current date and specific text as file name

    Hi all,

    Need some help here,

    I have a file in which i have created button, "Save File".

    When user click on the button, a copy of file should get saved as in the name of text "workfile" with current date.
    with one more condition
    The current file has 51 data rows excluding header.
    The copy of file should get saved with maximum of 24 rows of data only along with header.

    Since this file has got 51 data, then expected out put would be
    24 in file 1, 24 in file 2, rest 3 in file 3
    should be saved in desired path.

    Attached copy of file.
    Attached Files Attached Files
    Thank you

    If I have helped you in someway, use the * icon below to give reputation feedback, it is appreciated.

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: How to Save as a file with current date and specific text as file name

    Is the header exist in all files
    - Battle without fear gives no glory - Just try

  3. #3
    Forum Contributor prabhuduraraj09's Avatar
    Join Date
    05-19-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    330
    Quote Originally Posted by PCI View Post
    Is the header exist in all files
    Hi, Thanks for your reply.

    I have only one file which i attached.
    I need copy of file to be saved with header and with
    above said number of data and file name.

  4. #4
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: How to Save as a file with current date and specific text as file name

    See next code
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor prabhuduraraj09's Avatar
    Join Date
    05-19-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    330

    Re: How to Save as a file with current date and specific text as file name

    Hi PCI,

    Appreciate your response and yes this helps.

    Thanks alot.

  6. #6
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: How to Save as a file with current date and specific text as file name

    You're welcome

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] save file with current date
    By xi603 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 06-30-2017, 01:42 AM
  2. [SOLVED] Save selected print area as a pdf file using the text from a specific cells as the file na
    By A440 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-17-2015, 04:14 PM
  3. [SOLVED] VB to save to file of current date
    By sroot in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-18-2015, 07:16 AM
  4. [SOLVED] Save file as current date
    By Justair07 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-28-2014, 03:54 PM
  5. Save File as Current Date/Time
    By wxman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-08-2007, 08:30 AM
  6. Save File with Current Date Info
    By dianahatesboys in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-31-2007, 03:15 PM
  7. Save File with the current date and time.
    By sd in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-02-2005, 08:35 AM

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