|

Useful Keywords to Know in Excel Visual Basic

1.        The Application Keyword Use “Application” to refer to Excel, e.g.: Application.ActivePrinter Name of the Active Printer.Application.Name            Name of the program running (“Microsoft Excel”).Application.Path            The path from which the program is running. 2.        ActiveControl Instead of the name of a specific control (e.g. txtEdit), you can use the keyword ActiveControl.  This will let your program refer…