Access OLE objects using VBA

[Anonymous]

Dear all

If i have inserted an Excel OLE object in AutoCAD.
Is it possible to get the value in Excel OLE, through AutoCAD VBA.

How do we access ole objects through VBA????

Can we copy the Excel OLE object pasted in AutoCAD back to a new excel sheet using VBA???

Thanking in advance,

Vasant

[Anonymous]

Set a reference to the Microsoft Excel Object Libary 

Dim xlApp As Excel.Application

Dim wdApp As Word.Application

Dim acApp As Access.Application



Set xlApp = New Excel.Application

Set wdApp = New Word.Application

Set acApp = New Access.Application

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

"vasantshetty" <
href="mailto:vasant.shetty@hopeindia.com">vasant.shetty@hopeindia.com>
escribió en el mensaje
href="news:f13eb61.-1@WebX.maYIadrTaRb">news:f13eb61.-1@WebX.maYIadrTaRb...

Dear
all

If i have inserted an Excel OLE object in AutoCAD.
Is it possible to
get the value in Excel OLE, through AutoCAD VBA.

How do we access ole objects through VBA????

Can we copy the Excel OLE object pasted in AutoCAD back to a new excel
sheet using VBA???

Thanking in advance,

Vasant

[Anonymous]

OLE objects embedded in AutoCAD drawings cannot be manipulated with VB
or VBA.

--
Someone left the grass out in the yard all night.
http://www.acadx.com