$$Excel-Macros$$ Delete File Contents

2013-08-25 Thread pankajinfo
Dear Gurus, 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

Re: $$Excel-Macros$$ Re: Delete File Contents

2013-08-26 Thread pankajinfo
Ok can opt for Function if not then we will go with Macros On Mon, Aug 26, 2013 at 12:39 PM, Prince prince141...@gmail.com wrote: Pankaj i dont think it is possible without macro. You have to use macro to do this task. Regards Prince On Monday, 26 August 2013 09:30:57 UTC+5:30, Pankaj

Re: $$Excel-Macros$$ Re: Delete File Contents

2013-08-28 Thread pankajinfo
and automatically saves without confirmation. On Mon, Aug 26, 2013 at 2:40 PM, pankajinfo pankaji...@gmail.com wrote: Ok can opt for Function if not then we will go with Macros On Mon, Aug 26, 2013 at 12:39 PM, Prince prince141...@gmail.com wrote: Pankaj i dont think it is possible without macro

$$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

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

2013-09-02 Thread pankajinfo
Kumar.* ** ** *From:* excel-macros@googlegroups.com [ mailto:excel-macros@googlegroups.com excel-macros@googlegroups.com] *On Behalf Of *pankajinfo *Sent:* Friday, August 30, 2013 9:58 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Excel File Date Contents Deletion Macro

$$Excel-Macros$$ Macro File Saving Restriction

2013-09-16 Thread pankajinfo
Dear All, As you all know if a .xlsm or .xlsb file is saved under .xlsx or non-macro enabled file extension in those files macros do not work or visible. So i want to make a restriction in macro enabled files .xlsm or .xlsb that they cannot be saved under non-macro enabled file extension. Is it

$$Excel-Macros$$ File Saving Restriction

2013-09-18 Thread pankajinfo
Dear All, As you all know if a .xlsm or .xlsb file is saved under .xlsx or non-macro enabled file extension then in those files macros does not work or visible. So i want to make a restriction in macro enabled files .xlsm or .xlsb that they cannot be saved under non-macro enabled file extension.