The Excel Toolbar can be used as a file converter. Following example gives some idea how it Works.
MT940 files can be imported to Excel Toolbar. Using the Excel Toolbar features the data from MT940 file can be exported to a CSV file which can be utilized by other processes.
Worksheet list for processing MT940 files.
Parameters sheet is needed to create the SwiftTransactions sheet.
Figure 104. Parameter sheet.
Import MT940 file. Remember to use asterisk in the file name field if your file is not shown.
Import MT940 dialogue.
SwiftTransaction dialogue.
SwiftTransaction sheet is used as a source to the Deals sheet which is used to export data to CSV file.
