Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Here's how I reuse object refs...
Public oIE As SHDocVw.InternetExplorer Set oIE = New SHDocVw.InternetExplorer '//create instance '//use the instance for some processes Set oIE = Nothing '//destroy the instance ...where each time the object is needed a new instance gets created/used/destroyed. This usually requires some process to make repeated calls to the process using the object, and so you may need to restructure code accordingly. HTH -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I code the cloning of an object in vba? | Excel Programming | |||
Cloning an object which contains a collection | Excel Programming | |||
cloning sheets | Excel Discussion (Misc queries) | |||
file cloning | Excel Discussion (Misc queries) | |||
Best method of cloning the contents of a worksheet. | Excel Worksheet Functions |