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

Checkmark in Office Products

 Font: Wingding, ALT 0525: &#x2713 Note that the Unicode for that to be able to see it in HTML is  &#x2713 Note that the Blogger...