Thursday, February 24, 2011

Macro merge and visual basic

Most people have at least an understanding of the concept of merging in Word and Excel but too often have not tried it. The combination of macro, merge and Visual Basic makes it possible to create custom software for yourself if you can simply imagine what you would like to have happen.

You can merge from an assortment of data sources. In Microsoft Office, the most direct way is a Word text file or table, an Excel spreadsheet, or an Access database. And those are in reverse order of how I would recommend you try it.

That way you don't have to conform what you need to the reports and formats that are available, you can have something that is exactly what you want and need and it will not have a learning curve to use it.

No comments:

Post a Comment