RE: $$Excel-Macros$$ Excel File Date Contents Deletion Macro

2013-09-02 Thread Ravi Kumar
@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel File Date Contents Deletion Macro Thank You Ravi So Much for providing this code. this code can be used by Excel users whose data is used for presentations but they do not get credit for data compiling. On Fri, Aug 30, 2013 at 11:32 AM, Ravi

Re: $$Excel-Macros$$ Excel File Date Contents Deletion Macro

2013-09-02 Thread pankajinfo
gt; sh.Activate > > sh.ChartObjects.Delete > > Next**** > > ActiveWorkbook.Save**** > > ** ** > > End If > > ** ** > > Application.DisplayAlerts = True > > End Sub > > ** ** > > ** ** > > ** ** > > ** ** &

$$Excel-Macros$$ Excel File Date Contents Deletion Macro

2013-08-29 Thread pankajinfo
Dear All, I want to create a excel file with Date limit. Like in a file there are some contents(Graphs, Dashboards Etc) with 3 sheets. What i wants is after a time period like 31-Aug13 it gets expired and no one can open it or if someone opens after 31-Aug-13 it will delete all the file content