excel - How to export specific modified data from .xlsm to an existing .c file using VBA -

i'm new in vba, please excuse me if sounds not smart question.

so, have .xlsm file, select , modify data based on search criteria. have been able successfully, , displaying on sheet.

however, problem arises now- required take data, , put in particular format in existing .c file (whose path given input)

for example:

.xlsm sample data

part numbers aaaa1 bbbb2 cccc3 dddd4 

.c sample data

... ... { 0,   ...,   {'a','a','a','a','1'}, //part number in format   ...., } { 1,   ...,   {'b','b','b','b','2'},   ...., } { 2,   ...,   {'c','c','c','c','3'},   ...., } { 3,   ...,   {'d','d','d','d','4'},   ...., } 

how go this?