Re: $$Excel-Macros$$ Calculate Due dates

2011-05-04 Thread Mr excel
For example, The billing cycle for supplier A is 5th of this month to 4th next so all the transactions pertaining to Supplier "A" will be billed in this period. Here in this example, there is only one transaction related to "A" and the billing is done for the month of jan'2011 so in the month colum

$$Excel-Macros$$ Re: delete workbook if password is not entered

2011-05-04 Thread GoldenLance
With ThisWorkbook .ChangeFileAccess xlReadOnly Kill .FullName .Close 0 End With On May 4, 5:35 am, Bob wrote: > Can someone help with the code to delete a workbook if password is not > entered within 3 tries. Thanks so much! -- ---

Re: $$Excel-Macros$$ Calculate Due dates

2011-05-04 Thread ashish koul
can you expaln with some example in workbook On Tue, May 3, 2011 at 8:30 PM, keechak wrote: > Hi forum, > > Thanks very much for creating such a wonderful forum. > > I had a problem in calculating the due dates for different customers. > > Col A contains suppliers with the dates they supply the

Re: $$Excel-Macros$$ excel 2003 or 2007???

2011-05-04 Thread ashish koul
Sub test() If Application.Version = "12.0" Then code for excel 2007 End If If Application.Version = "11.0" Then code for excel 2003 End If End Sub On Wed, May 4, 2011 at 4:32 PM, Pravin Kumar wrote: > Hi > > is there any code that will allow me to run the first macros if the user is > excel 200

$$Excel-Macros$$ excel 2003 or 2007???

2011-05-04 Thread Pravin Kumar
Hi is there any code that will allow me to run the first macros if the user is excel 2003... and the second if the user is excel 2007. regards Pravin -- -- Some important links for excel users: 1. Follow us on TWITT

Re: $$Excel-Macros$$ help Please

2011-05-04 Thread Kabir....:-)
Dear Mahesh, May i know how this is possible. I want to learn it. Thanks in advance. Regards, Saroj. On Tue, May 3, 2011 at 10:58 PM, Mahesh parab wrote: > Hi > check attach, whether its as per u r requirement > > On Tue, May 3, 2011 at 8:29 PM, m7md.gmail wrote: > >> all, >> please i need