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

VBA Excel to Double Click change to checkmark or x

 Note that to do this, you need to set the font of the affected cells to Winding 2 first: 1 2 3 4 5 6 7 8 9 10 11 12 Private Sub Worksheet...