Macro to group and save. [Closed]

Question

Macro to group and save. [Closed]

Report

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

Hello,

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.

Macro to group and save.
Insert Picture in Excel macro, after crop it, save it to a file ✓ - Forum - Excel
Excel - A macro to perform calculation and save data on another sheet - How-To - Office Software
Excel - A macro to auto-save documents - How-To - Excel
Macro not saving file in excel format ✓ - Forum - Excel
Excel macro save as cell value and date ✓ - Forum - Excel

1 reply

Ask a question

swe1 · Accepted Answer · 2009-03-25T22:28:20-0400

Answer 1 / 1

swe1
Mar 25, 2009 at 10:28 PM

Bump

Macro to group and save. [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!