NAG and Microsoft Excel - Expand your capabilities

Learn how to maximize Excel's potential with the NAG Library.

One of the major benefits of the NAG Library is its inherent flexibility; it can be used by programmers developing in traditional languages, or by users of modern software packages and programming environments, like Microsoft Excel.

To make using the NAG Library easy, we provide the Library as a Dynamic Link Library (DLL). Despite the relatively simple methods of linking to the Library from Excel, it's important to note that to gain benefit from NAG routines in this manner you'll need to be capable of programming in either Microsoft Visual Basic for Applications (VBA) or Visual Studio for Office (VSTO).

The 'NAG and Microsoft Excel' area of the NAG website has been created as a central repository for those wishing to either:
 

• Learn about linking NAG functionality to Excel via the NAG Dynamic Link Libraries
• Open, view and experiment with NAG routine examples from within Excel
• Using the NAG Library for .NET in Excel
• Read white papers and technical reports on using NAG in Excel
• Leave feedback for NAG's technical team on your experiences on using NAG in Excel and / or suggest future development ideas

Interactive demonstrations showing the use of NAG routines in Excel

These demos highlight the ease with which Excel-based applications that utilize routines from the NAG Library may be developed. Examples are presented for beginner programmers, and for those that are more experienced.

Recorded web demonstrations highlighting NAG in Excel functions show the ease of application development

• Portfolio Optimization Example (using the NAG library from Excel)
• Option Pricing Example (using the NAG library from Excel)

Please click here to view recorded webinar clips highlighting NAG in Excel functions.

White Paper/Technical Reports

NAG experts and collaborators working at other organisations and learning institutions have written papers and reports about using NAG routines in Excel. Links to various reports are featured below.

• Using the NAG Library to calculate financial option prices in Excel
• Sample Microsoft Excel Projects Illustrating How to Call the NAG C Library
• NAG DLLs and Microsoft Excel and Microsoft Visual Basic for Applications
• How to call NAG functions with Microsoft Access and Excel data
• A step by step guide to using the NAG Fortran Library with Microsoft Excel 2003
• Tech Tip: Calling NAG Routines from Excel
• Tech Tip: Using NAG with Microsoft Excel (32-bit or 64-bit)?

Header files for the NAG Libraries

Visual Basic NAG header files (for use in VBA)

• Header files for 32-bit NAG Fortran Library FLDLL244ML
• Header files for 32-bit NAG C Library CLW3223DAL

Visual Basic .NET NAG header files (for use in VSTO)

• Header files for 32-bit NAG Fortran Library FLDLL234ML
• Header files for 64-bit NAG Fortran Library FLW6I23DCL
• Header files for 32-bit NAG C Library CLW3223DAL
• Header files for 64-bit NAG C Library CLW6I23DAL

Not found what you're looking for?

If you'd like to talk to us about your requirements for mathematical and statistical functionality to enhance your use of programming using Excel either email us at nagmarketing@nag.co.uk or call us directly.