90 likes | 108 Views
This presentation explores integrating newlook with standard desktop applications using DDE and API calls. Learn how to integrate your iSeries application with MS Word, Excel, Lotus Notes, and email.
E N D
Integrating newlook • In this presentation… • Integrating your underlying iSeries application with 3rd party applications. • Using DDE and the API. • Using Call and Declare.
Integrating newlook • Integrate newlook • Refers to integrating newlook with standard desktop applications, such as MS Word, Excel, Lotus Notes and Email. • Key newlook tools • Designer • Macro Editor
Integrating newlook – DDE & API • DDE macro actions • LinkInitiate • LinkExecute • LinkPoke • LinkTerminate
Integrating newlook – DDE & API • Sample DDE commands • Word[SetDocumentVar “Balance”, “999.99”][EditSelectAll][UpdateFields][SendKeys {home}] • Excel[Workbook.Activate (“Sheet1”)][Echo (0)]
Integrating newlook – Call & Declare • Call and Declare • Declare (library, procedure, alias, return values, arguments) • Call (procedure, arguments and return values) • Sample Call and Declare • Declare(Kernel32.dll, WritePrivateProfileStringA, WritePrivateProfileString, Boolean, ByVal Section as String, ByVal Key as String, ByVal Value as String, ByVal File as String) • Call(WritePrivateProfileString, "Section", "Key", "Data", "myapp.ini", rc)
Integrating newlook – DDE & API • newlook API (for external applications) • NL_GetVersion • NL_EnumInstances • NL_GetValue • NL_SetValue • NL_RunMacro
Integrating newlook – DDE & API • Using the newlook API • 32 bit • Visual BasicSamples\Visual Basic\ApiTest • Visual C++Samples\Visual C++\ApiTest • Other languagesLink with NLAPI.DLL
Summary • newlook can be used to integrate your underlying iSeries application. • The key tools used in integrating your application are Designer, Macro Editor and the Expression Builder. • You can use DDE and API calls to export data to common desktop applications, e.g. MS Word and Excel.
Workshop 6 newlook 8 Training