Introduction:
There are actually two different ways to accomplish this task, depending on exactly what you want to do. You can:
- Connect to an existing application (uses the GetObject method)
- Create a new application with no document loaded (uses the CreateObject method)
Please note that while all of this code was written to control Microsoft Word from Excel, you can use it in any other VBA enabled application, and you can also use it to control any other VBA enabled application, simply by changing "Word" to Excel, Powerpoint, Access, etc... in the examples below.
...
Knowledge Base Articles By Category
Recent Forum Posts
...
Not able to figure out how to fetch a column value present in a different excel sheet
Here you go:
AliGW Today, 02:43 PM=LOOKUP(2,1/((Sheet2!$A$2:$A$11=A2)*(Sheet2!$C$2:$C$12=4)),Sheet2!$B$2:$B$12)...