Using UpReplace Within Excel Spreadsheets

If you create a Visual Basic (VB) function named UpReplace within an Excel spreadsheet and set its return value to True, you instruct FDM to delete all data from the TDim table before data is loaded.

Example:

Public Function UpReplace() as Boolean
‘Set value to true to force delete prior to load
UpReplace = True
End Function