Has anyone have any experience at converting PICK files (PEQS hold
entries, et al) to a MSWord document, or vice-versa. And/or, use of
MSWORD escape characters being incorporated in a PICK document, for
font control, etc.

Thanks, in advance, for your assistance.

JJCSR wrote:
If I understand it correctly (going out on thin ice, that) a .DOC
document is more like a binary picture than a text document the way you
and I might think of it.
Art

Hi Jim - I have extensive experience integrating Word, Excel, and
Outlook with MV environments. The following link is to a product that
is no longer offered, but it gives you an idea of what's possible:
removethisNebula-RnD.com/products/doc.htm

You don't want to put escape codes into your data, but you certainly
can pull data fields into Word templates or build Word docs from
scratch. My code creates a new Word document, pulls in text, and
formats it using the Document Object Model in Word. These days if I
were to re-write NebulaDoc I would probably do it using XML rather
that integrating directly into the Word DOM. I just did this with
Excel, so now I can use simple calls from BASIC to create real nicely
formatted Excel docs via XML. It's not as feature rich as building
Excel files with the DOM (no charts or pivot tables which I did have
in my NebulAnalysis product) but it's good enough for what most people
do in Excel.

I'm not sure what your project is, but our ConnectingFlight service
converts JET to real Word documents, not RTF or plain text:
removethisNebula-RnD.com/services/connflight.htm
The same code has been enhanced over time to use Runoff, UltiWord,
DocuMentor, OP, and other variants as the source, and to go through
word to create PDF, HTML and other final doc formats.

For reports, there is no magic tool that will make a plain greenbar
report pretty, but there are tools available which allow you to
develop attractive report templates using a GUI. When reports are run
through the templates (no different than selecting any printer), data
is extracted and the resulting output has a nice "this millenium"
look, with images, lines, colors, fonts, etc.. These tools and
related services can be expensive if you want to do something like
this with no code changes at all. I know of at least three sources.
If you don't mind copying and modifying your existing reports to run
through a graphical template rather than PRINTing directly to a
printer, then this can probably be done for a lot less- maybe using
Word.

So... what's on your mind?

HTH
Tony
TG@ please.remove.anti.spam.textNebula-RnD.com

JJCSR wrote:

On May 23, 4:48 am, JJCSR <JCro... (AT) ktp (DOT) com> wrote:
You might want to check out our WordLynx product, which has been in
use for over a decade, enabling you to use Microsoft Word for forms &
report production from your "pick" environment. You can download an
eval and have a look at the manual here http://www.stamina.com.au/support/downloads.htm
- have a play & it may help solve your current problem

Depending on the REAL problem you are trying to address (which I don't
think you have described), then other solutions like our
Visage.ReportServer may be more appropriate. Feel free to contact me
directly if you want/need more details

Latest version of MSOffice saves/loads documents in XML format with
support of all features. But it is not easy.

With BRIZ You can work with MSWord and MSExcel directly from
DataBasic. (With help of Special ActiveX)