Copy worksheet information to Word using VBA in Microsoft Excel

If you are required to copy & paste data from multiple excel worksheets into MS Word then you should read this article. In excel, there is no such...

Determine if an application is available using VBA in Microsoft Excel

To find out the status of any particular application available or running in Microsoft Excel, take a look at this article. We will use VBA code to che...

How to do Conditional Formatting using VBA in Microsoft Excel

Let's paint a Monalisa painting and leave Picasso behind using VBA. Ready, Get Set … Wait! Wait! Hold your horses. We are just going to use VBA t...

Control Word from Excel using VBA in Microsoft Excel 2010

Many a times, you have to copy data from an excel file to a word document.  You can do this with a macro very easily. The macro will open a new / exi...

Control Outlook from Excel using VBA in Microsoft Excel

The two example macros below demonstrates how you can send information to Outlook (e.g. sending an e-mail message) and how you can retrieve informati...

Control Excel from Word using VBA in Microsoft Excel 2010

There are times we have to copy data from a word document to an excel file.  We can do this very easily with a macro in all version of office.  Th...

Adjust row height of merged cells using VBA in Microsoft Excel

Question: Merged cells do not have the correct height after a row break. How can I correct this? Answer: Insert the following code in the standar...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube