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
