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