How to use OLE in excel 2000 for getting or sending to other applications.........

[prakashsakthivel]

Hi Members,

Could anybody please tell that

How to use OLE in Excel 2000 for sending or getting data from other applications
like .exe, or .xls

Thanks
musai.

[kadghar]

Hi Members,

Could anybody please tell that

How to use OLE in Excel 2000 for sending or getting data from other applications
like .exe, or .xls

Thanks
musai.

Well, it depends on what application you want to work with. If you can retrieve information from it with an OLE automation or ActiveX, then it shouldnt be a hard task. Just check the libraries for the methods an properties (you can google them).

Here's a little example with the IE.
[CODE=vb]sub TSDN()
dim Obj1 as object
set obj1= createobject("i nternetexplorer .application")
obj1.visible=tr ue
obj1.navigate "http://www.thescripts. com"
end sub[/CODE]