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

    Joined:
    Apr 20, 2008
    Messages:
    559
    Likes Received:
    376
    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
    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.

    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