Tag Archives: Office

Use a password protected Access database in C#

Posted on May 10, 2018 by RodStephens

This example shows how you can open and use a password protected Access database in C#. It also shows how you can use the database’s password protection to provide a login form for your program. Note that the security used … Continue reading →

Posted in database, Office | Tagged Access, C#, C# programming, database, example, example program, Office, password protected Access database, passwords, Windows Forms programming | Leave a comment

Use VBA macros to add hyperlinks to external files

Posted on March 20, 2018 by Rod Stephens

My book Essential Algorithms: A Practical Approach to Computer Algorithms has associated instructor materials that include lesson plans and PowerPoint presentations that are accessible via hyperlinks. The materials include a summary Excel workbook that contains hyperlinks that let you open … Continue reading →

Posted in Excel, Office, PowerPoint, Word | Tagged C#, C# programming, create hyperlink, example, example program, Excel, hyperlink, Office, PowerPoint, remove hyperlink, VBA, Visual Basic for Applications, Windows Forms programming, Word | Leave a comment

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

Create a PowerPoint presentation from a Word document in C#

Posted on February 7, 2018 by Rod Stephens

This example shows how you can create a PowerPoint presentation containing slides that correspond to selected styles in a Microsoft Word document. How to Use It Enter or select a Word document and a destination PowerPoint presentation. Enter the styles … Continue reading →

Posted in interoperability, Office, Word | Tagged C#, C# programming, create PowerPoint presentation, DOCX, docx to ppt, example, example program, interoperability, Microsoft PowerPoint, Microsoft Word, Office, PowerPoint, ppt, Windows Forms programming, Word, Word to PowerPoint | 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

Save Excel data in a PDF file in C#

Posted on December 7, 2017 by Rod Stephens

This example extends the example Write Excel data in C#. See that example for information on how to open an Excel workbook, write data into it, and save it. Note that before you can use the Excel interop library, you … Continue reading →

Posted in Excel, Office | Tagged C#, C# programming, example, example program, Excel, make PDF file, Office, PDF, PDF files, save PDF file, Windows Forms programming | 1 Comment

Book Errata Page: The C# Helper Top 100

Posted on September 4, 2017 by RodStephens

This is the errata page for my book The C# Helper Top 100, The 100 most popular posts at csharphelper.com. If you find mistakes, please post them here in the Leave a Reply box at the bottom of the page. … Continue reading →

Posted in .NET, algorithms, books, C#, C# programming | Tagged .NET, algorithms, animation, API, books, C#, C# Helper, C# programming, classes, clipboard, combinatorics, cryptography, curve fitting, dialogs, drag and drop, drawing, events, example, example program, Excel, files, fractals, FTP, graphics, image processing, interop, interoperability, mathematics, multimedia, Office, printing, Rod Stephens, serialization, system, threading, tips, tools, Windows Forms programming | 2 Comments

Book Discussion Page: The C# Helper Top 100

Posted on September 4, 2017 by RodStephens

This is a discussion page for my book The C# Helper Top 100, The 100 most popular posts at csharphelper.com. Please post questions, thoughts, and suggestions here in the “Leave a Reply” box at the bottom of the page. I … Continue reading →

Table of Contents: The C# Helper Top 100

Posted on September 4, 2017 by RodStephens

This is a brief summary of the book’s table of contents. Introduction Part I. Serialization 1. Read a CSV File into an Array (1) 2. Use JSON to Serialize and Deserialize Objects (49) Part II. Graphing 3. Draw a Graph … Continue reading →