Monday, July 25, 2011

Wings to Tally

Here are sample files for importing data from Wings Software to Tally

1) Import Cash Vouchers from Wings Software to Tally
2) Import Sales Vouchers from Wings Software to Tally

Wednesday, July 20, 2011

Excel 2010 - Error 800A3EC

In case, if you are using Excel 2010 or Excel 2007 and get the Ole Error 800A3EC while importing data into Tally using UDIMagic, then it is likely that VBA is NOT installed in your system.

VBA macros in 2010, 2007
Prior to Excel 2007 you didn't need to install the Visual Basic Editor if you wanted to develop or run macros (VBA procedures). In Excel 2007, Excel 2010 you must specify that VBA be installed when you install Excel from the Office CD. See how to install Visual Basic for Application for Excel 2010 / 2007

Tuesday, July 19, 2011

VBA Replace function

Replace(cString , cFind , cReplaceWith)


Replace(cString, "A","a")

The above replaces all occurrences of  capital "A" with small "a" in the cString variable.

The VBA Replace function is very useful for manipulating Excel data at runtime. In certain cases, where the Excel data is generated from 3rd party softwares, we faced certain issues. Example, the Amount was displayed in TEXT format and included comma separator like 1,50,000.00. We used the VBA Replace function to remove the commas and then convert the value to Numeric.

Friday, July 15, 2011

Excel to Tally - Sample Excel sheet formats

The following sample Excel sheet format is now available for UDIMagic users :-

Financial Vouchers with Cost Category and Cost Centres