by David Hakala
Sometimes you have a repetitive task that cannot be recorded by Excel’s macro recorder. Take, for instance, this fairly common example. You need to create a new worksheet, give it a name, place it at the end of all the tabs in your workbook, and save the updated workbook.
(more…)
by David Hakala
Suppose you have a database of company information and contacts. You want to use an Excel macro to copy addresses and such into different Word documents. How can you make Excel open a specific Word document into which information will be pasted?
Word’s mail merge feature is one solution. But if you are working with multiple Word documents, the mail merge trick won’t work. You will need something more complicated called Office Automation, which allows creation of macros that work with multiple Office applications and not just one, such as Word.
(more…)
Powered by WordPress