#84 QuantLibXL RateCurveFramework 64-bit Excel VBA patches

[paronam]

1) Can't diff XLA/XLAM files but here are changes needed to these files/modules:

Launcher.UtilsWindows
FixedIncome.KeyState
FixedIncome2.KeyState
Utilities.Windows

Just replace Declare statements near top with these conditional declarations.

FixedIncome.KeyState:

#If VBA7 Then
    Private Declare PtrSafe Function GetKeyState Lib "user32" ( _
    ByVal nVirtKey As Long) As Integer
#Else
    Private Declare Function GetKeyState Lib "user32" ( _
    ByVal nVirtKey As Long) As Integer
#End If

FixedIncome2.KeyState:

#If VBA7 Then
    Private Declare PtrSafe Function GetKeyState Lib "user32" ( _
    ByVal nVirtKey As Long) As Integer
#Else
    Private Declare Function GetKeyState Lib "user32" ( _
    ByVal nVirtKey As Long) As Integer
#End If

Launcher.UtilsWindows:

#If VBA7 Then
    Declare PtrSafe Function WNetGetUser Lib "mpr.dll" _
    Alias "WNetGetUserA" (ByVal name As String, _
    ByVal userName As String, bufLen As Long) As Long
#Else
    Declare Function WNetGetUser Lib "mpr.dll" _
    Alias "WNetGetUserA" (ByVal name As String, _
    ByVal userName As String, bufLen As Long) As Long

#End If

Utilities.Windows:

#If VBA7 Then
    Declare PtrSafe Function WNetGetUser Lib "mpr.dll" _
    Alias "WNetGetUserA" (ByVal name As String, _
    ByVal userName As String, bufLen As Long) As Long
#Else
    Declare Function WNetGetUser Lib "mpr.dll" _
    Alias "WNetGetUserA" (ByVal name As String, _
    ByVal userName As String, bufLen As Long) As Long
#End If

2) Need to update ID 16 in Loader.xls to "QuantLibXL-vc120-x64-mt-s-1_7_0.xll"

3) Need to create workbooks folder in main dir. Workbooks from 32bit package appear to be missing

4) Some problems remain with Developer functions not recognizing that Debug.xla is not loaded

[Luigi Ballabio]

May you report this at https://github.com/eehlers/QuantLibXL/issues? Thanks.