Open and fill cells in Excel via automation.
Each cell will be filled by the content of VB6 Text1 Text2 Text3 etc so VB6 interface skills required.
There are less than 20 textboxes.
Code you create may be similar to VBA but deliverable must be VB6 EXE PRJ FRM etc.