By way of introduction, all databases created by Flexcom have “header” information detailing, among other things, the locations of blocks of data within the database. These blocks contain results for parameters such as axial strain, bending moments etc. Refer to Database Access Routines if you are interested in further details. When you load a database file into Excel, the “header” information is retrieved only once, for efficiency, and is stored in a “cache” or location in memory.
The purpose of this function is to clear the “cache”, and reread the “header” information from the database file. This is a very important function, as it may be used to ensure the contents of the Excel workbook if fully up to date.
UpdateHeaderIfChanged (string DatabaseName)
DatabaseName (string). The full path name to the relevant database.
DatabaseName