" Live as if you were to die tomorrow. Learn as if you were to live forever.. "
- Mahatma Gandhi

Creating Macros in Excel

Posted on November 23rd, 2015 by Srikant Das

Macros are nothing but short cuts for creating repetative tasks in Excel. Following are the steps outlined to create a new macro. 1. Click on Start>Programs>Microsoft office>Microsoft Excel to open the application. Then, go to Start>New to open a new spreadsheet. Go to File>Save as and save the new file as Book1.xls 2. Go to […]

Open MS WORD or MS EXCEL document and set focus in Vista

Posted on November 23rd, 2015 by Amrita Dash

In VISTA when you try to open a word document or excel sheet from your program [VB.NET code], it  always gets minimized to the taskbar.To resolve this issue you can use the following command of AppActivate. [VB.NET] ‘ CREATE AN OBJECT FOR WORD Dim objWord As Object objWord = CreateObject(“Word.Application”) objWord.visible = True ‘ OPEN […]

Working with mail merge word document using VB.NET

Posted on November 23rd, 2015 by Amrita Dash

This tip demonstrates how to attach the DB source and populate fields from table to a mail merged word document in VB.NET. Code Snippet Dim objWord As New Object objWord = CreateObject(“Word.Application”) ‘ Creating a word application Dim objDoc As New Object objDoc = CreateObject(“Word.Document”) ‘ Creating a word document object objWord.application.WindowState = 0 ‘ […]