Using Ms Word OLE in Powerbuilder??
I'v recently enherited a PowerBuilder app that strips data out of DB2 and
inserts it into A Word mail/merge document for printing using OLE. It was
built for use with Word 5.0. We've gone to Office 97. It no longer works
(same old story).
Here is the offending code:
It stops on the first line and the error message says that the "EditGoTo
property was not found"
Can someone stear ...Euro symbol from PowerBuilder to Word via OLE
when our users type or paste a Euro symbol into a datawindow
and save, it is fine, but when they generate a Word document
via OLE, the symbol is corrupted
any ideas ?
...Help Needed for
Using Ms Word OLE in Powerbuilder??
I have one report which I wanted to be in Word document. Although it is not
exactly mailmerge, I want to replace few of the fields in the word document
with the database fields.
The problem I am facing is Word says
'Name not found calling external function goto at line ...'
I tried using Word 97 / Word 2000 ( PB version is 6.5)
The code I wrote is
ole_object = CREATE OLEObject
li_rtn = ole_object.ConnectToNewObject("word.application.8")
if li_rtn = 0...can powerbuilder ole 2.0 with MS word possibly suck as bad as it seems to?
i've been trying to support what should ostensibly be a very simple
procedure using ole automation with ms word 6.0 as the server. as far as
i can tell, unless i'm really crazy, the same line(s) of code produce
different results, randomly. moreover, pb 5.0 doesn't seem to support
the majority of wordbasic's functionality due to its "function" format
as opposed to wordbasic's dot format, i.e. editgoto() vs.
editbookmark.Name = "schmoe", .SortBy = 0, .Goto Insert "Joe".
does anyone know whether or not pb 5.0 (enterprise) has a crappy ole...OLE From Word To PowerBuilder
I have been having a problem, I have a PB App that uses Word to open
documents stored in a database. When a document is open, a Word macro is
executed that searches the letter for a place where there needs to be a
signature. If there is a signture needed, it communticates back to
PowerBuilder that the current user signature is needed. It works great
with DDE, but I run into a problem with OLE. How do cummunicate with a
PowerBuilder Appilcation that is already running? As it is right now, I
have to build a runtime DLL, or use the "PowerBuilder.Application" an...Ole Word and Powerbuilder
Please help if someone knows how to convert Visual Basic commands to
Powerbuilder. I create bookmarks on the fly and populate them with descriptions.
Some descriptions I have to insert with tabbing or indentions. I need correct
syntax for Powerbuilder. What I used is not working.
iole_object.Selection.Font.Underline = False
iole_object.Selection.Font.Bold = False
These commands are fine. I have no problems.
Powerbuilder doesn't accept commands like :
1) iole_object.Selection.Paragraph.TabIndent or
iole_object.Se...PowerBuilder and MS Word Mailmerge
Since Office 2003 and Office XP I made mail mergue using the MSD of MS Word
but with these new versions of office all that code does not work now.
Does anyone know how to perform MailMerge with these new word versions?
Thank yu in avance
first you have to prepare a csv datasource for mail merge operation. to
create a datasource take a look at the following snippet:
string ls_sql, ls_presentation, ls_syntax, ls_err, ls_datasource_filenm
// replace ? of as_sql with value of criteria
if as_sql <> "" then as_sql = of...Powerbuilder 8 and MS Word
I want to use word in PowerBuilder's application wich open a
Word's file and put in some data coming from ASA (for
For example, the word's file must containing
"Dear Client Mister XXX, etc ... and your Contract Number is
where XXX and YYY are extracting from ASA.
This file must be opened in Powerbuilder's application and
saving after in Database.
How is it possible to do this ?
Thanks for your help.
you should be able to start an ole connection to the msword
http://sybooks.sybase.com/onlinebooks...Powerbuilder and MS Word 2000
I am currently experiencing two problems with PowerBuilder 7.0 (Build
6012) and Microsoft word 2000. I am supposed to print a 1 page Word
document before the user prints any report. Please see the code that
follows this message. This code was working fine with MS Word �97.
After installing Word 2000, I have come across two problems. The first
one occurs where I open the file and printing that file. (
io_reportdoc.documents.open(ls_filename), io_reportdoc.printout()) It
takes way too long to open and printing. I would like to minimize the
time. The second problem is th...Powerbuilder & MS Word
Could anybody suggest a good reference book for PB OLE with MS WORD?
I've never discovered one.
However, all of the MS Word functions are documented in Word itself. From
the Word main menu, choose Tools .. Macro .. Visual Basic Editor. Then,
from the VB Editor, View .. Object Browser.
All of the classes and methods are there, along with the values of constants
that you'll need - but all of the examples in the help are, of course, in
VB. It is definately possible to translate to PB, but it takes a little
If you have a specific question about how to do...URGENT ! POWERBUILDER + WORD + OLE
I need to change, from my PowerBuilder application, the print
specification of a Word Document before its printing (which paper to use,
scale, where to find the paper in the printer, ...)
Is it possible with OLE or DDE ?
How to do it ?
Thanks for all !!!
Use INI file settings, i.e. specify 'tray' and 'paper type' to use.
Note: It will be hardware dependant
> Hello all,
> I need to change, from my PowerBuilder application, the print
> specification of a Word Document before its printing (which paper to use,
>...PowerBuilder 5 and Word 2000 with OLE
I'm trying to insert an OLE control into a window. If I select 'Microsoft
Word Document' in the 'Insert Object Window' and try to insert the OLE
Object into the window PowerBuilder crashes.
I using Powerbulder version 5.0.4 and running Windows NT and Office 2000
Actually, I have the same problem and I've observed that there is no such
problem on "fresh" computers - with Windows and Office only.
After you install another applications the Word's OLE object stops working
properly with PB. I think that ...problems with Word ole and Powerbuilder 5
I'm using PowerBuilder 5.03 and when I run this code under windows 95, 98 it
works, but when I run this code under Windows NT, it crashes.
Thanks in advance and sorry for my english
ole_object = CREATE OLEObject
// Connect to Word 8 (starts Word 8) , if successful Opens employee.doc ,
// if unsuccessful , display msg box for "ole error".
IF ole_object.ConnectToNewObject("word.application") = 0 THEN
// Make Word 8 visible - ( Set to FALSE for Word 8 to be invisible )
ole_object.docu...PowerBuilder 10.2 with Word OLE
I am having a crazy hard time trying to figure out what is
wrong with this PowerBuilder interaction with Microsoft Word
2003. After upgrading from Windows 2000 and Office 2000 to
Windows XP and Office 2003, document corruption seems to
occur (4 bytes of garbage scattered throughout the document
file). Both methods of accessing the OLE/Word DOM are being
used. One with the ActiveX control on a form and the other
using the CREATE OLEObject. Word is being used to view,
edit, print, find and replace text, and render PDF
documents; no mail merges or nothing complicated like that.