Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 21st 04, 10:12 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2004
Posts: 1
Default Error accessing external object property vbe

Hi, All!
I wrote in client programm (PowerBuilder) some program in which I Ope
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.I nsertLines( 1,Re
)
It works FINE with Office97, 2000. But when I tried to run this progra
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
member of
"Application" Object.
But when I tried to watch description of this object in low info windo
I
get error message "Cannot jump to
"VBE" because it is in the library "VBIDE" which is currentl
referenced"
In menu "Tools\References" I didn't found such a library?
Thanks in advance,
Nilov Serge

--
Message posted from http://www.ExcelForum.com


  #2   Report Post  
Old June 21st 04, 12:48 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2004
Posts: 74
Default Error accessing external object property vbe

Hi,

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?


I imagine that this is because "Trust access to Visual Basic project" is
unticked in the Tools Macro Security dialog.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.ie




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
runtime error 434, object does not support this method or property Janis Excel Discussion (Misc queries) 4 January 17th 08 04:10 PM
VBA error: "object doesn't support this property or method" Dave F Excel Discussion (Misc queries) 2 April 23rd 07 06:04 PM
Error accessing external object property XVALUES sergio Excel Discussion (Misc queries) 2 February 7th 07 04:47 PM
Object doesn't support this property or method (Error 438) Kiran Excel Discussion (Misc queries) 1 July 12th 05 08:42 PM
Accessing the VBA project object model Tom Ogilvy Excel Programming 0 July 8th 03 02:47 PM


All times are GMT +1. The time now is 01:07 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017