If Microsoft Excel is invoked by an automated process, the <SAS Financial Management Functions.xla> file is not loaded and this causes SAS Financial Management CDA functions to fail. If you have added VBA code to your report/form, the VBA code will log on to the SAS Financial Management Add-in for Microsoft Excel and the functions will recalculate properly when the VBA code is executed interactively within Excel, but not if the Excel startup is automated.

There is a workaround to this. The following should be added to your VBA code if you wish to automate the Excel startup:

' Automated Excel does not install .xla 
' files. This code finds and installs the
' SAS Financial Management Functions.xla

Dim CurrAddin As addin
 
    For Each CurrAddin In Application.AddIns
      If UCase(CurrAddin.Name) = UCase("SAS Financial Management Functions.xla") Then
        If CurrAddin.Installed Then
            CurrAddin.Installed = False
            CurrAddin.Installed = True
        Else
            CurrAddin.Installed = True
        End If
      End If
      
windows("WorkbookWithMacro.xls").Activate

Operating System and Release Information