Connect Tally from Excel

If you are trying to connect Tally from Excel and you do the following process.

 

First try connecting a new Query

 

 

Select Tally ODBC

 

 

 

 

If you don’t find the same then ODBC is not enabled in the Tally. Kindly enable by doing the following

 

1.      On the Gateway of Tally, go to configuration F12

 

 

2.      Select Advance configuration

 

 

 

3.      Enable the ODBC

 

 

 

 

 

 

 

 

 

Generate Random Names

In Excel you can always generate Random Numbers, but for some reason you need Random NAMES quickly, use this link here

http://listofrandomnames.com/

Reverse the Text in Excel

Use this code

 

Function Reversestr(str As String) As String

    Reversestr = StrReverse(Trim(str))

End Function