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
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,687
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,025
Messages
5,835,010
Members
430,332
Latest member
Charly_Moon

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