NEW3.02.03 · Released 22 November 2019
NEWfinPOWER Connect
Released in
3.02.03
22 November 2019
  1. Opened22 Oct
  2. Closed22 Oct
  3. Released22 Nov
Article 16469 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")