View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Afshar Mohebbi Afshar Mohebbi is offline
external usenet poster
 
Posts: 3
Default Using COM objects in Excel or VBA?

Hi after a month!!

NickHK,
It was very helpfull, I use it in ESRI ArcGIS (ArcMap) a GIS
application and it worked well.

Thanks Again
Afshar


NickHK wrote:
Afshar,
Basically, you need to add a reference to your components from the Excel
VBEToolsReferences.
Then :
Dim MyInstance As MyCom.MyClass
Set MyInstance=New MyCom.MyClass

With MyInstance
.Dosomething argument1,etc...
End With

'Finished, so free up
Set MyInstance=Nothing

NickHK

"Afshar Mohebbi" wrote in message
oups.com...
Hi Leith,
But this link seems to be about the COM itself, not using it in Excel.
I've already written and used COM in several cases.

Regards,
Afshar

Leith Ross wrote:
Hello Afshar Mohebbi,

Your question is really to in depth to answer by post. Microsoft has a
good site that should answer your questions. Here is the site to visit
http://tinyurl.com/ltl2w

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile:

http://www.excelforum.com/member.php...o&userid=18465
View this thread:

http://www.excelforum.com/showthread...hreadid=557658