7

Using Business Rules in Excel with Visual Basic, Script Lab, or Office Scripts

In the previous chapter, we said that no matter what technique we use to link Excel to our decision service, the approach is similar. We’ll prove that in this chapter. Power Query is a great approach but has limitations. We’ll explore linking Excel and decision services using Visual Basic, Script Lab, or Office Scripts – which approach you use is your choice. Along the way, we’ll cover the following topics:

  • Calling decision services from Excel using Visual Basic for Applications
  • Installing Microsoft Script Lab and using it to link Excel with our decision service
  • Introduction to Office Scripts and making the link to our decision service using that Excel script online ...

Get AI and Business Rule Engines for Excel Power Users now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.