1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Excel macro help

Discussion in 'General Programming Chat' started by Choronzon, Oct 21, 2009.

  1. Choronzon

    Choronzon Power Member

    Apr 20, 2008
    Likes Received:
    Is there anyone who is good with excel macros that can help me out.

    I have a spreadsheet with all of my data in and I am trying to automate it with a macro so that at the end of the week it will save the spreadsheet to an archive somewhere as a seperate workbook (preferably with a filename based on the current date) and then clear the sheet ready for the next weeks data.

    Can anyone help me with a solution or even just point me to a place where I might find a solution, I have searched G00gle up and down and can't even find anything close.
  2. jmann0305

    jmann0305 Newbie

    Nov 7, 2009
    Likes Received:
    middle of nowhere
    Home Page:
    try this out it should at least get you started.. If I'm not mistaken it should be as easy as just hitting a record button preforming the task you are looking to automate and then saving the macro. But then again I'm not a macro expert so. Anyway here is the link.


    Also, it took me like 1.1 sec to find that page. Maybe you should google harder lol. ;)