Tag Archives: Microsoft Office

Use VBA to randomize cells in Excel

Posted on March 5, 2018 by Rod Stephens

This is quick excursion into Excel VBA programming. This example uses a VBA macro to let you randomize the selected cells in an Excel workbook. If you select a contiguous block of cells and click the Randomize button, the following … Continue reading →

Posted in Excel, Office, VBA | Tagged C#, C# programming, example, example program, Excel, Microsoft Excel, Microsoft Office, Office, randomize, randomize Excel, VBA, VBA programming, Visual Basic for Applications, Windows Forms programming | Leave a comment

Use Word to make a PDF containing pictures in C#

Posted on January 23, 2018 by Rod Stephens

The example Make a Word document containing pictures in C# shows how to make a Word document containing pictures taken from selected files. This example is similar to the that one (see that post for details) except it saves the … Continue reading →

Posted in files, graphics, interoperability, Office, Word | Tagged C#, C# programming, directories, example, example program, files, graphics, image, interoperability, make PEF, Microsoft Office, Microsoft Word, Office, PEF, picture, Windows Forms programming, Word | Leave a comment

Make a Word document containing pictures in C#

Posted on January 22, 2018 by Rod Stephens

Occasionally you may want to combine selected pictures to make a Word document. This example shows one way you can search for files matching a pattern and then add them to a new Word document. This is a fairly long … Continue reading →

Posted in files, graphics, interoperability, Office, Word | Tagged C#, C# programming, directories, example, example program, files, graphics, image, interoperability, Microsoft Office, Microsoft Word, Office, picture, Windows Forms programming, Word | 3 Comments

Examine the unique words in a Microsoft Word file in C#

Posted on August 30, 2017 by RodStephens

This example is a modification of the earlier post List the unique words in a Microsoft Word file in C#. That program reads the words in a Microsoft word file, sorts them, and then displays the unique words in a … Continue reading →

Posted in files, Office, strings, Word | Tagged C#, C# programming, count words, example, example program, files, Microsoft Office, Microsoft Word, Office, strings, unique words, Windows Forms programming, Word, word count | Leave a comment

Convert RTF and TXT files into DOCX files in C#

Posted on January 19, 2017 by Rod Stephens

First add a reference to Microsoft.Office.Interop.Word. To make using the library easier, add this using statement: using Word = Microsoft.Office.Interop.Word; When you enter the input and output file names and click Convert, the program uses the following code to open … Continue reading →

Posted in files, interoperability, Office, Word | Tagged C#, C# programming, DOCX, example, example program, files, interoperability, Microsoft Office, Microsoft Word, Office, RTF, TXT, Windows Forms programming, Word | Leave a comment

Add and remove pictures in an Excel worksheet

Posted on November 24, 2015 by Rod Stephens

This is another brief foray into VBA programming. When you click the Insert Image button, the following VBA code executes. ‘ Insert a picture at the selection. Sub Button1_Click() Dim filters As String Dim filename As Variant ‘ Define the … Continue reading →

Posted in Excel, Office, VBA | Tagged example, example program, Excel, insert picture, Microsoft Office, Office, remove picture, VBA, Visual Basic for Applications, Windows Forms programming | Leave a comment

List the unique words in a Microsoft Word file in C#

Posted on May 31, 2015 by Rod Stephens

The example List unique words in a text file in C# shows how to list the unique the words in a text file. This example shows how to list the unique words in a Microsoft Word file. Before you start, … Continue reading →

Posted in files, Office, strings, Word | Tagged C#, C# programming, count words, example, example program, Microsoft Office, Microsoft Word, Office, strings, unique words, Windows Forms programming, Word, word count | 1 Comment

Add a picture to a Word document in C#

Posted on November 15, 2014 by Rod Stephens

This example shows how a C# program can add a picture to a Word document. It also shows how to use a bookmark to find the beginning of the Word document, make text flow around the picture, and align the … Continue reading →