How can I generate a markup of a text file

ziggle

New Member
Joined
May 9, 2007
Messages
15
Hi folks,

I have created a VB routine that processes some accounting records that exist as text files. No problem. I have generated a report and people are all happy. However, there is one request that I have not been able to honor at this point. They would like the input text files modified in some way to mark the text fields that I used in the text files to generate the reports. Today they manually go through and, with a pen on paper, circle all the fields they used to generate the report. I would like to automate this process.

Any thought on how I could generate a version of the input file with the text fields I used marked in some way, like with colored characters. I have thought about HTML. The folks here like to work with Word. Any thoughts on how to create a Word-readable file with colored text that is not HTML? RTF?

Zig
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,531
Can I ask why you can't create an Excel document for this? Why use Word?
 

ziggle

New Member
Joined
May 9, 2007
Messages
15
Hi GlennUK,

They are trying to come up with an application that strictly works out of Excel. While they can use Word, they are MUCH more comfortable with Excel. They want to hit a button in Excel and have the data analyzed, the report generated, and markups put into a special directory.

I may have just got it working. At this point, I have used VBA to output the accounting data to a file with an RTF header and with every line terminated with a "\par". I marked every data item used with red color. From Excel, I have printed the RTF file to a PDF generator and everything looks good.

Thanks for looking at my question.

Zig
 

Watch MrExcel Video

Forum statistics

Threads
1,122,838
Messages
5,598,383
Members
414,234
Latest member
grlevesq

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top