Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have found a module which starts as follows:-
------------------------------------------------------------------------------ ' This module contains routines for cubic spline interpolation and integration. ' Designed for Microsoft Excel 97 and beyond ' Written 1999/6/30, David J. Braden ' Revisions: ' 1999/7/2 DJB Made 2nd derivative at upper endpoint exact ' Tightened up input validation code ' 1999/7/6 DJB Streamlined (optional) error-checking ' About 20% of the code is for checking that input is valid, hence the length. ' If you "know" that input is always valid, set the compiler directive ' fValidateInput = True. -------------------------------------------------------------------------- etc. etc what exactly do I need to do to add this module which contains functions and subroutines to an excel workbook 2003 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Did you try copy and paste into a VBA module?
"Bob Mat" wrote: I have found a module which starts as follows:- ------------------------------------------------------------------------------ ' This module contains routines for cubic spline interpolation and integration. ' Designed for Microsoft Excel 97 and beyond ' Written 1999/6/30, David J. Braden ' Revisions: ' 1999/7/2 DJB Made 2nd derivative at upper endpoint exact ' Tightened up input validation code ' 1999/7/6 DJB Streamlined (optional) error-checking ' About 20% of the code is for checking that input is valid, hence the length. ' If you "know" that input is always valid, set the compiler directive ' fValidateInput = True. -------------------------------------------------------------------------- etc. etc what exactly do I need to do to add this module which contains functions and subroutines to an excel workbook 2003 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
yes
"JLGWhiz" wrote: Did you try copy and paste into a VBA module? "Bob Mat" wrote: I have found a module which starts as follows:- ------------------------------------------------------------------------------ ' This module contains routines for cubic spline interpolation and integration. ' Designed for Microsoft Excel 97 and beyond ' Written 1999/6/30, David J. Braden ' Revisions: ' 1999/7/2 DJB Made 2nd derivative at upper endpoint exact ' Tightened up input validation code ' 1999/7/6 DJB Streamlined (optional) error-checking ' About 20% of the code is for checking that input is valid, hence the length. ' If you "know" that input is always valid, set the compiler directive ' fValidateInput = True. -------------------------------------------------------------------------- etc. etc what exactly do I need to do to add this module which contains functions and subroutines to an excel workbook 2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Initialization using Multipage Tab | Excel Programming | |||
initialization of an array???? | Excel Programming | |||
ActiveX Progress bar initialization in Excel 2003 problem | Excel Programming | |||
ActiveX initialization in Excel | Excel Programming | |||
List box initialization | Excel Programming |