I am extracting data from Excel worksheet and write to the WORD file.
I wrote VB code on the EXCEL itself in modules
So each record will be a word doc. I am writing values to the word doc.
so I am using something like,
Set pen = createTextFile(filename)
pen.WriteLine(put stuff here)
Can I format the text I write??? (FONT, BOLD, COLOR...etc)
Example will be like this:
1) Name: XXXX
XXXXX are coming from Excel..