#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default OLE Object

i've got a problem with an ole object...

following situtation:
- insert a worksheet as an ole object in open worksheet
- change some data in ole object

code (i write it by heart - maybe there are some errors):

Dim objOLE As OLEObject
Set objOLE = ActiveSheet.OLEObjects.Add( _
Filename:=ThisWorkbook.Path & "\Template.xls", Link:=False,
DisplayAsIcon:=False)

Dim myWorkbook As Workbook
set myWorkbook = objOLE.Object

With myWorkbook.Sheets(1)
.Range("$C$3") = "Whatsoever"
'do so for several ranges
End With

myWorkbook.Close

the code works without a problem, but shows no reaction. the oleobject
does not update. fine.
meanwhile i recognized the .VERB method and even if i don't like the
way it work - it seems to work - as long as i test my code step by
step. if i RUN the code i get an error message when i try to close the
workbook and excel crashes.

so please - somebody show me the right handling of the VERB method
(please complete code) or a possiblity to update the ole object (as
mentioned above).

that's all folks
rené

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
2 Label Options - Forms Object vs Control Box Object Awrex Excel Discussion (Misc queries) 3 July 17th 09 07:10 PM
Option button object proeprties or object not found in vba Pete Straman S via OfficeKB.com Excel Programming 0 August 31st 05 05:49 PM
Confusion about how the Window object fits into the Excel object model Josh Sale Excel Programming 11 April 15th 05 06:08 PM
How to Add an Object to the New Object List in windows 2000 Bubu Excel Programming 5 June 3rd 04 12:42 PM
Range object to Array object conversion Alan Beban[_3_] Excel Programming 0 August 1st 03 01:24 AM


All times are GMT +1. The time now is 04:08 AM.

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

About Us

"It's about Microsoft Excel"