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 […]

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 […]

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 ‘ […]