90 likes | 335 Views
Integrating new look. In this presentation… Integrating your underlying iSeries application with 3 rd party applications. Using DDE and the API. Using Call and Declare. Integrating new look. Integrate new look
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