Macro to group and save.

swe - Mar 23, 2009 at 09:22 AM
 swe1 - Mar 25, 2009 at 10:28 PM

I need to write a macro for a workbook with 1 sheet where i need to got to
data --> then select Group/outline ---> then select group

when the window opens in the start date it needs to get the latest date from the column "C" and the year from Column "A".
and end date should be 4 months from the start date.

Then select years and click ok.
Then save this workbook as "WeeklyClosingsReports and date(date should be the start date)"
date format: "mm/dd/yy".

Following is the code i get when i record this macro.

Sub clsrep()

Selection.Group Start:=39895, End:=40017, Periods:=Array(False, False, _
False, False, False, False, True)
End Sub

Thanks in advance.

1 response