Solidworks 2014, SP 4.0,64bit

Excel 2010 64bit

Returns null when I try to get the path of the macro folder from solidworks.

My Code

Private Function GetDBPath() As String

'Gets the JobDataBase path based on solidworks application.

    Dim SwApp As SldWorks.SldWorks

    Set SwApp = CreateObject("Sldworks.Application.22")

    'Set SwApp = Application.SldWorks

    GetDBPath = SwApp.GetCurrentMacroPathFolder()

End Function

References, Solidworks 2014 Type Library is added

I tried this in above code and returns english

? swapp.GetCurrentLanguage()

Any thoughts would be greatly appreciated.