"VBIDE" is currently referenced" ?

[Nilov Serge]

Hi, All!
I wrote in PB some program in which I Open excel file from disc and I write
some VBA code in an Excel's sheet.
I did it so:
WEObject = Create OleObject
if WEObject.ConnectToNewObject("Excel.Application") = 0 THEN
...
WEObject.WorkBooks.Open(ExcelFileName)
...
WEObject.Application.VBE.CodePanes(1).CodeModule.InsertLines( 1,Res )
It works FINE with Office97, 2000. But when I tried to run this program on
Office2003(11.5612.5606) I got the error:
" Message:Error accessing external object property vbe at line 236 in
function ...".
What is the matter ? Microsoft changed it's VBA object structure?
In Excel's Object Browser by searching "vbe" I see tham "vbe" is a member of
"Application" Object.
But when I tried to watch description of this object in low info window I
get error message "Cannot jump to
"VBE" because it is in the library "VBIDE" which is currently referenced"
In menu "Tools\References" I didn't found such a library?
Thanks in advance,
Nilov Serge.

[Bruce Armstrong [TeamSybase]]

Are you sure the Primary Interop Assemblies are installed for Office
2003? I believe you have to do a custom or complete install to get
them. If you do a standard install you won't have them:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_wrcore/html/wrtskInstallingOfficePrimaryInteropAssemblies.asp

On 16 Jun 2004 01:17:20 -0700, "Nilov Serge" <ns...@cable.netlux.org>
wrote:

Bruce Armstrong [TeamSybase]
http://www.teamsybase.com

Two new books on developing with PowerBuilder
http://www.pb9books.com?source=newsgroups

Need code sample? Check out CodeXchange:
http://www.codexchange.sybase.com

ISUG Enhancement Requests
http://www.isug.com/cgi-bin/ISUG2/submit_enhancement

Preach the gospel at all times. If necessary, use words. - Francis of Assisi
http://www.needhim.org

---------------------------------------------------------------------
DISCLAIMER:

This newsgroup message is only intended for the recipient. Given that it
is a posting to a public newsgroup, that means if you can read this
message then you are the recipient. This message may contain information
that is confidential and protected from disclosure. And then again,
it may not.

Given that TeamSybase members are not employees of Sybase, the contents
of this message do not necessarily represent the views or policies of
Sybase. Given that TeamSybase is a diverse group of users of Sybase
products, the contents of this message do not necessarily represent the
views of a significant number of the members of TeamSybase. Given that the
author has mutliple personalities and hears voices in his head, the contents
of this message do not necessarily represent his own views.