On Apr 8, 2006, at 12:25 PM, Chris Malumphy wrote:
I would like to create a Word document from information that I
currently have in a Database. I have no problem extracting the data
from my DB using RB. What I need to learn is how to format the output
for Word.
How is that done? Is it easy or difficult? Is there an example
anywhere?
There will be 200 to 300 pages of output. All except the cover page
will have essentially the same format. Headers, footers, colheads and
some data need to be in Bold. Headers and footers need to be in
italics and in a different font and font size. The data needs to be in
columns or tables (some left aligned and some right aligned) but with
no border lines. I need to have page breaks at appropriate sections
and I would like to number the pages.
I've used Office automation quite a bit and works pretty well. There
should be some basic examples of how to interface with the automation
tools in the RB examples. That will get you started.
To see how to do more advanced operations you can use the macro
recorder in MS Word. Start recording a macro and begin creating and
formatting your document the way you want. Stop the macro and then
view the code it creates. This will get you pretty close to the code
you will need in RB. The formatting is slightly different between MS
Word macros and RB Office automation, but it's pretty easy to figure
out the changes you need to make.
One note - in my experience Office automation can be very slow
sometimes on Mac. On Windows it will fly.
Greg
--
LecShare, Inc.
P.O. Box 1119
Clayton, NC 27528
919.934.3810 (voice)
919.882.1275 (fax)
http://www.lecshare.com
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
