Article Details
Id:16469
Product:finPOWER Connect
Type:NEW
Version:3.02.03
Opened:22/10/2019
Closed:22/10/2019
Released:22/11/2019
Job: J023166

ISUserInterface; add access to ISAccess, ISExcel and ISWord objects

Access to functionality such as ISExcel have been added to the Business Layer that scripts can run. In particular the ISUserInterfaceBL class.

This includes new functions:

  • Access to access ISAccess
  • Excel to access ISExcel
  • Word to access ISWord
  • OpenAssociatedApplication

Note, this functionality requires a script of type "General (User Interface)".

Sample code shown below.

With userInterface.Excel
  .Open()
  .Show()
  .DocumentOpen("C:\Data\Book1.xlsm")
  .MacroRun("Macro1")
End With
userInterface.OpenAssociatedApplication("C:\Data\Book1.xlsm")