Invoke VbMacro from Oracle6i pl/sql

[Guest]

Greetings!

I'm generating a word document from an Oracle 6i application, using a
template (Cardio.dot) witch has specific autotext.

Unfortunately, I'm stuck with a strange error: when I open the new generated
document, the autotext isn't there and the document is tied to the normal.dot
template and not my Cardio.dot template.
But if I renamed my template to normal.dot (and setting normal.dot to
normalOld.dot, for instance) it worked properly!

So I have two questions:

--> Do you know any Oracle 6i package to manipulate word documents?
--> Do you know any Oracle 6i package to rename files?

Thanks for your help!

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?cmljYWZvcnJpY2E=?=,

I'm generating a word document from an Oracle 6i application, using a
template (Cardio.dot) witch has specific autotext.

What command are you using to create the document from the template?

Unfortunately, I'm stuck with a strange error: when I open the new generated
document, the autotext isn't there and the document is tied to the normal.dot
template and not my Cardio.dot template.
But if I renamed my template to normal.dot (and setting normal.dot to
normalOld.dot, for instance) it worked properly!

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[Guest]

Hello!

I'm using a library called oleword, which I believe has been implemented
some years ago!

The following methods are used:

procedure filenew(ow in ole2.obj_type, str_filenew in varchar2, template in
varchar2) is
arg OLE2.LIST_TYPE;
begin

odebug.f_debug_rotina_3param_in('filenew','str_filenew',str_filenew,'','','','');
arg := ole2.create_arglist;
ole2.add_arg(arg,template);
ole2.add_arg(arg,1);
ole2.invoke(ow,str_filenew,arg);
odebug.f_debug_rotina_3param_out('filenew','','','','','','');
ole2.destroy_arglist(arg);
exception
when odebug.wordole_exception_305500 then
odebug.f_erro_rotina_3param('filenew','ERRO
305500','ow',odebug.oleobject2char(ow),'str_filenew',str_filenew,'template',template);
odebug.f_erro_rotina_end('filenew');
raise odebug.wordole_error;
when others then
odebug.f_erro_rotina_3param('filenew','ERRO
OUTROS','ow',odebug.oleobject2char(ow),'str_filenew',str_filenew,'template',template);
odebug.f_erro_rotina_end('filenew');
raise odebug.wordole_error_others;
end;

procedure fileopen(ow in ole2.obj_type, str_fileopen in varchar2, name in
varchar2) is
arg OLE2.LIST_TYPE;
begin
arg := ole2.create_arglist;
ole2.add_arg(arg,name);
ole2.invoke(ow,str_fileopen,arg);
ole2.destroy_arglist(arg);
end;

I don't think this can help much...

Ricardo

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?cmljYWZvcnJpY2E=?=,

I don't think this can help much...

You're right, it's not making a lot of sense. I don't think
you're going to get much help in this (an END-USER) group.
You might find someone in an office.developer group with an
idea about the interface you're using.

My best guess would be that Word isn't able to find that
template you think you're using, so is defaulting to
Normal.dot on receiving a Documents.Add command.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail