Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Walter,
The work done by the object instance happens in its own separate procedure from the procedure using the object. So your instantiation procedure is a reusable utility that your business logic code uses to process its data, or retrieve data for the business logic code to process. IOW, it's a 2-way street in terms of how data flows. So... Dim oIE As Object Sub GetDataFormIE(<datacontainer,<other args if any) Set oIE = CreateObject("InternetExplorer.Application") '//load datacontainer as required Set oIE = Nothing End Sub Optionally: Dim vIE Sub GetDataFormIE(<datacontainer,<other args if any) Set vIE = CreateObject("InternetExplorer.Application") '//load datacontainer as required Set vIE = Empty End Sub ...where your caller procedure will process the contents of datacontainer. If there's no data then IE didn't give it up; -so check how you load datacontainer above... Sub DoThis() Dim vData Call GetDataFormIE(vData) '//process vData End Sub -- 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 |
Reply |
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 |