John Hufnagel: Opening Excel application using VBA

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

Subscribe to: Post Comments (Atom)