Re: $$Excel-Macros$$ Copy Sheet and Name the sheet with todays date

ay, February 29, 2012 6:42 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Copy Sheet and Name the sheet with todays > date > > First: > save your file as .xlsb or .xlsm... > Then create a Workbook Open event macro in the Thisworkbook module: > >

Re: $$Excel-Macros$$ Copy Sheet and Name the sheet with todays date

Sub Don Guillett SalesAid Software dguille...@gmail.com From: Paul Schreiner Sent: Wednesday, February 29, 2012 6:42 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Copy Sheet and Name the sheet with todays date First: save your file as .xlsb or .xlsm... Then create a Workbo

Re: $$Excel-Macros$$ Copy Sheet and Name the sheet with todays date

Dear Sundar, Wrong attachment, Please ignore it.. On Wed, Feb 29, 2012 at 6:21 PM, NOORAIN ANSARI wrote: > Dear Sundar, > > Please see attached sheet, you can use.. > > Sub Count_VBA() > On Error Resume Next > c = 1 > For Each Sh In ActiveWorkbook.Sheets > If Sh.Name <> Sheets("Summary") Then >

Re: $$Excel-Macros$$ Copy Sheet and Name the sheet with todays date

First: save your file as .xlsb or .xlsm... Then create a Workbook Open event macro in the Thisworkbook module: Private Sub Workbook_Open()     Dim Sht     Err.Clear     On Error Resume Next     Sht = Format(Now(), "dd-mmm-yy")     Sheets(Sht).Select     If (Err) Then     Sheets("TEMPLATE").Co