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.
Click to continue reading…

Create Word Documents from Excel Macros

in applications

With Office Automation, you can create macros to make Excel open a Word document so information can be pasted into it.

Read the full article