Excel macro help

Choronzon

Power Member
Joined
Apr 20, 2008
Messages
553
Reaction score
381
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.
 
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
 
Back
Top