Can I call a macro function in excel from SalesLogix and return the result using the excel application object?

Question:
Can I call a macro function in excel from SalesLogix and return the result using the excel application object?

Answer:

Dim xlApp
Dim xlBook
Dim szResult

Set xlApp = CreateObject(“Excel.Application”)
Set xlBook = xlApp.Workbooks.Open(“U:SLXTest.xlsm”)

szResult = xlApp.Run(“SLXTest.xlsm!SLXCheck”, edtnumberfield.Text)
MsgBox szResult

xlBook.Close False
Set xlBook = Nothing
xlApp.Quit
Set xlApp = Nothing

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!