Wednesday 24 July 2013

How can we Invoke and terminate an Instance of Excel!!

'Variable to store excel application object

Dim xlApp

'Create a new instance of the excel application
'by default the application starts in invisible mode ,which helps
'In performing start up @ initialization operations in the back ground


set xlapp=createobject("Excel.application")

'make the application visible

xlapp.visible=True

msgbox "The excel application has been Invoked"

'Terminate the excel instance just started

xlapp.quit

'destroy the refernse of the object

set xlapp=nothing

No comments:

Post a Comment