Property get procedure did not return an object

oliviers · Joined: 18 Dec 2007 Posts: 1

Hi,

I get the error message "Property let procedure not defined and
property get procedure did not return an object" while trying to loop
on a workbook's sheet:

for each sheet in workbook.sheets
....
next

i guess something is wrong with the Excel library?

Any tip/help welcome.

Olivier

Archived from group: microsoft>public>vb>ole>automation

OnAction property Does anyone know how to link a macro with the clicking of a menu item that has just been created in Word from VB6? The macro will be created in VB6. I know that the 'OnAction' property looks for the macro to run when the menu item is clicked but it looks

setting the MAPIMessages RecipIndex property I am trying to loop through and display all the recipients on a MAPIMessage using the RecipIndex property. According to the VB6 Language Reference: I s

Strange behavior when setting custom property! Hello! I have the follwing problem: Im using a Java-COM Bridge and I try to add a custom property to a document (which is in an OLE container) and set a value for this property: Variant result = new Object[]{ new Integer

Expose Object Dear all, I would like to know how to build application that can be embedded by another application (ole automation server) developed with vb 6.0. Thanks for suggestion Jamil

Can I Do This Using the Excel Object? Sorry if this not the right group, I'm new to OOP and OLE. I trying to find out if I can automate the sizing of all the columns in an Excel worksheet. I have managed to open the workbook I want, add a new sheet and format and copy several columns from she