Hence, UDIMagic searches for the macro-file in the UDI Magic startup folder. XML tags for Loading / executing the Macro fileġ) In the first example, we have not specified the full-path for the macro-file. Here's a simple macro file (Exercise-15-macro.txt) which displays a message.ġ) Sub.End Sub is used to declare a procedure / routine.Ģ) Google for "Excel VBA" for more help on writing VBA macros.īefore we write XML tags for importing data from our Excel sheet into Tally, let's have a look at the UDI Magic supported XML tags for loading and executing macros. You can use Notepad (or any text-editor) to create macro files.
To begin with, we shall write a simple macro that displays a message "Hello World". In this exercise, we shall take up "How to use VBA (Visual Basic for Applications) with UDI Magic ?" In simple words, VBA allows you to do almost any task that you can manually do in MS-Office Applications. Using VBA, you can sort data perform calculations insert or delete columns or rows in MS-Excel at run-time. UDI Magic v3.0 or higher supports the use of VBA. VBA or Visual Basic for Applications is a light weight programming language (quite similar to Visual Basic) that allows automation of tasks in MS-Office Applications.
In the Daybook.xml file, refer to the tags that appear within the tag and try relating the same with the tags as given in the XML tags for this exercise. This will generate the tags in Daybook.xml file.
Next, export it in XML format using option "Gateway of Tally > Display > Daybook > Alt+E". All you need to do is to manually enter the sample data (only 1 voucher) as given in the Excel sheet into the Tally Software. You can get the Tally supported tags for Vouchers from Tally Software itself. UDIMagic first processes the MASTER tags and then the VOUCHER tags.Ģ. You can also view it online by clicking on the link given above.ī. Please refer the XML tags file for complete tags. The XML tags to create Ledger Masters look like this :-Ī. As you can see in the Excel sheet snapshot, the Column C contains Party Names whereas the Column D contains the Sales Ledgers. Here's what the sample Excel sheet looks like.ĭownload the Excel sheet with the XML tags.ġ) First, you must write XML tags to create Masters (i.e. As this is the first exercise (for Vouchers), we have purposely taken up a simple Excel sheet. Here's a sample Excel sheet that contains Sales Vouchers (without Items).
0 kommentar(er)
