MS Word VBA add footer to all word documents in folder

This MS Word VBA tutorial explains how to add footer to all word documents in a folder automatically. MS Word VBA add footer to all word documents in a folder A couple of years ago, my manager asked me to add the keyword Public / Confidential / Restricted to all Word documents footers to meet compliance requirement (this is a common practice), I painfully did it manually for hundreds of documents. In fact it could have been done automatically. In some of my previous posts, I have demonstrate...
Read More

Excel VBA export Excel to Word

This Excel VBA tutorial explains how to export Excel to Word. You may also want to read: Export Excel to PDF Excel VBA export Excel to Word In the previous post, I demonstrated how to export Excel to PDF, which is very easy because there is already a built in function to do that (using Save As and choose PDF). However, there is no built in function to export Excel to Word. Fortunately Excel cell is actually a table in Word, we can simply copy the cells and paste to Word. This tutorial ex...
Read More