Welcome to Yavatmal Division

.

Monday, May 17, 2010

Treasury-Account-Head-Problem

Download and run attached exl. ( Download )execute the attached script using script tool.if the accountheads are required for the current date execute the following:use treasurygoupdate_megh66_accountheadsif the accountheads are required for a particular date:use treasurygoupdate_megh66_accountheads_bydate 'ddmmyy'in this ddmmyy explanation is as follows:if the date is 07/05/2010 then it will be equal dd/mm/yyyy so the ddmmyy will be 070510. This can be applied to any date on the same analogy.