Sunday 22 July 2012

How to plan tax



Tax Planning for House
Advanced Tax Planning 
   Effective Tax planning is an important feature to financial success for businesses. The tax laws are the same, no matter what size the corporate taxpayer. The difference is the ability of the large business firms to use......

How to go about tax planning for 2012-13
One of the leading financial planners in Mumbai raised a very pertinent question: Why is it that almost every person has budget for running....
E-filing of Income Tax Return 

Monday 16 July 2012

How to load library files without setting in QTP

Work without QTP for loading the library files and picked the current path automatically.
'===================================================
    'How to work without QTP with excel and load the vb library without using the QTP tool
    set wshell = createobject("wscript.shell")  
                        CurrentPath =  wshell.currentdirectory    
                        DFA_DFA_Dictionary= CurrentPath & "\DFA_Library\DFA_Dictionary.ini"  
                        DFA_SummaryResult_Library = CurrentPath & "\DFA_Library\DFA_SummaryResult.ini"                         


                                                    AddLibrary DFA_DFA_Dictionary  ' to add library during execution using vbs script        
                                                    AddLibrary DFA_SummaryResult_Library  ' to add library during execution using vbs script     

Function AddLibrary(FileName)
                Dim fsObj : Set fsObj = CreateObject("Scripting.FileSystemObject")
                Dim vbsFile : Set vbsFile = fsObj.OpenTextFile(FileName, 1, false)
                Dim myFunctionsStr : myFunctionsStr = vbsFile.ReadAll
                ExecuteGlobal myFunctionsStr
                vbsFile.Close
                Set vbsFile = Nothing
                Set fsObj = Nothing
End function