Excel macro help

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

  1. Choronzon

    Choronzon Power Member

    Joined:
    Apr 20, 2008
    Messages:
    556
    Likes Received:
    367
    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

    Joined:
    Nov 7, 2009
    Messages:
    14
    Likes Received:
    5
    Location:
    middle of nowhere
    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.

    http://office.microsoft.com/en-us/excel/HA010548371033.aspx

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

    Jmann