| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
clear object
Hi, I have created an object "Orders" with twenty properties.
Is there any instruction I can use to clear all the properties of the object without having to go Orders.OrderID="" Orders.AttemptID="" etc. Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
clear object
Have you tried
set orders = nothing set orders = new objName Robin Hammond www.enhanceddatasystems.com "Steve" wrote in message ... Hi, I have created an object "Orders" with twenty properties. Is there any instruction I can use to clear all the properties of the object without having to go Orders.OrderID="" Orders.AttemptID="" etc. Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
clear object
Much obliged.
Thankyou "Robin Hammond" wrote in message ... Have you tried set orders = nothing set orders = new objName Robin Hammond www.enhanceddatasystems.com "Steve" wrote in message ... Hi, I have created an object "Orders" with twenty properties. Is there any instruction I can use to clear all the properties of the object without having to go Orders.OrderID="" Orders.AttemptID="" etc. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 Label Options - Forms Object vs Control Box Object | Excel Discussion (Misc queries) | |||
| Transfer a name from one cell to another but leave clear if clear? | Excel Worksheet Functions | |||
| Not at all clear on use of variables and/or object variables | Excel Discussion (Misc queries) | |||
| clear the clear the web page email attachment lines | Excel Discussion (Misc queries) | |||
| Excel 97 - Clear Method Of Range Object Failed | Excel Programming | |||
![Steve[_42_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
