+ Reply to Thread
Results 1 to 4 of 4

Saving a monthly report using Visual Basic

  1. #1
    Ant
    Guest

    Saving a monthly report using Visual Basic

    Every month I save a hardcopy version of a report into a folder. I want to
    run a macro to do this which amongst other things, names it after the
    respective month. ie in Jan the macro saves the hardcopy report as
    Report_Jan.xls. In February I want the macro to save it as Report_Feb.xls.
    etc.

  2. #2
    Chip Pearson
    Guest

    Re: Saving a monthly report using Visual Basic

    Try something like

    ActiveWorkbook.SaveAs Filename:="Report_" & Format(Now,"MMM") &
    ".xls"


    --
    Cordially,
    Chip Pearson
    Microsoft MVP - Excel
    Pearson Software Consulting, LLC
    www.cpearson.com




    "Ant" <[email protected]> wrote in message
    news:[email protected]...
    > Every month I save a hardcopy version of a report into a
    > folder. I want to
    > run a macro to do this which amongst other things, names it
    > after the
    > respective month. ie in Jan the macro saves the hardcopy report
    > as
    > Report_Jan.xls. In February I want the macro to save it as
    > Report_Feb.xls.
    > etc.




  3. #3
    Ant
    Guest

    Re: Saving a monthly report using Visual Basic

    So...would that save it as FEB if it is actually February? And if I save it
    today for example it would save it as MAR? If so, I really need it to save to
    a month that I can manually select, for example, I need to save it as FEB
    today, not MAR (It's a month end report you see, so will always be a month
    behind the actual month). Can I point the name of the month to a cell that
    has data validation?

    "Chip Pearson" wrote:

    > Try something like
    >
    > ActiveWorkbook.SaveAs Filename:="Report_" & Format(Now,"MMM") &
    > ".xls"
    >
    >
    > --
    > Cordially,
    > Chip Pearson
    > Microsoft MVP - Excel
    > Pearson Software Consulting, LLC
    > www.cpearson.com
    >
    >
    >
    >
    > "Ant" <[email protected]> wrote in message
    > news:[email protected]...
    > > Every month I save a hardcopy version of a report into a
    > > folder. I want to
    > > run a macro to do this which amongst other things, names it
    > > after the
    > > respective month. ie in Jan the macro saves the hardcopy report
    > > as
    > > Report_Jan.xls. In February I want the macro to save it as
    > > Report_Feb.xls.
    > > etc.

    >
    >
    >


  4. #4
    David
    Guest

    Re: Saving a monthly report using Visual Basic

    =?Utf-8?B?QW50?= wrote

    > So...would that save it as FEB if it is actually February? And if I
    > save it today for example it would save it as MAR? If so, I really
    > need it to save to a month that I can manually select, for example, I
    > need to save it as FEB today, not MAR (It's a month end report you
    > see, so will always be a month behind the actual month). Can I point
    > the name of the month to a cell that has data validation?
    >


    If you have a date that reflects that month somewhere in the report you can
    include part of that cell's value in the filename. i.e.:

    ActiveWorkbook.SaveAs Filename:="Report_" & Format(Range("g2"), "mmm") &
    ".xls"

    --
    David

+ 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