roscoe
Well-known Member
- Joined
- Jun 4, 2002
- Messages
- 1,062
- Office Version
- 365
- Platform
- Windows
- MacOS
I'll start by apologizing for my vagueness but I'm working on a proprietary project of which I can't disclose much, but seeking advice for a feature I'd like to implement.
My project is time oriented such that it pulls in time-based data from a server, adds data provided by the user, and presents an XY chart that has time across the X-axis (bottom) and a lot of horizontal lines showing events by start/stop times (staggered vertically by type of event...very similar to a Gantt chart).
One of the products I produce from this is a text file listing all of the events in chronological order. This gets imported manually by the user into a word doc that requires formatting per our company "standard" appearance. Because my product is a text file, it has no formatting, so the user has some work to do to convert the data from text to "usable". I'd like to automate this for the user.
I'd like to learn to create a word doc (this isn't hard) and push properly formatted data to it. In this case properly formatted means to assign the appropriate color (based on the line's content) and set tab stops (which should be the same for every line). In some cases the color may change mid-line.
(Note: Google was not helpful. Nothing in regards to tab stops. I also found a post where the problem was fixed by associating the appropriate Word library (to access Word VBA constants) but didn't describe how or what library).
Any point outs to good resources (or straight tips!) would be greatly appreciated!!!
My project is time oriented such that it pulls in time-based data from a server, adds data provided by the user, and presents an XY chart that has time across the X-axis (bottom) and a lot of horizontal lines showing events by start/stop times (staggered vertically by type of event...very similar to a Gantt chart).
One of the products I produce from this is a text file listing all of the events in chronological order. This gets imported manually by the user into a word doc that requires formatting per our company "standard" appearance. Because my product is a text file, it has no formatting, so the user has some work to do to convert the data from text to "usable". I'd like to automate this for the user.
I'd like to learn to create a word doc (this isn't hard) and push properly formatted data to it. In this case properly formatted means to assign the appropriate color (based on the line's content) and set tab stops (which should be the same for every line). In some cases the color may change mid-line.
(Note: Google was not helpful. Nothing in regards to tab stops. I also found a post where the problem was fixed by associating the appropriate Word library (to access Word VBA constants) but didn't describe how or what library).
Any point outs to good resources (or straight tips!) would be greatly appreciated!!!
Last edited: