Thursday, November 21, 2013

Opening Excel application using VBA

In the references, add in "Microsoft Excel n Object Library".

Then the code should look as follows:

Dim exApp As Excel.Application
Set exApp = CreateObject("Excel.Application")
exApp.Visible = True

No comments:

Post a Comment

OneNote Math Operations

  Supported arithmetic operators Operator Meaning Example +  (plus sign) Addition 3+3 -  (minus sign) Subtraction Negation 3-1 -1 *  (asteri...