March 24, 2019
Hot Topics:

OLE Automation Servers

  • November 20, 2002
  • By Developer.com Staff
  • Send Email »
  • More Articles »

Ole Automations are very powerful in Visual Basic it is a further advancement to linking objects.Using OLE automation we can control the source Document from within our application .The control can happen through the objects that are exposed by the source Document.

The Getobject method.

A Getobject method can open to excel objects and use them to create a client/Server application. The Getobject method has the following syntax:


To open an excel object the syntax is:


Alternate to Getobject is the createobject method which has the following syntax:


The Following code helps opening an object in XLS:

Dim XLSsheet as object
set XLSsheet=Getobject("text.xls","excel.sheet")

Thus an Exposed object can be used to do the calculation rather than doing that at the client end.

Comment and Contribute


(Maximum characters: 1200). You have characters left.



Enterprise Development Update

Don't miss an article. Subscribe to our newsletter below.

Thanks for your registration, follow us on our social networks to keep up-to-date