Erick's Blog
  • Home
  • Blog
  • Apps
    • Mortgage Calculator
  • PowerShell
    • Blog & Examples
    • Excel Reference
  • Windchill
    • Document Exporter
    • Document Worker
    • E.P.L.E.S.
    • Export Released
    • Property Checker
    • Windchill Business Analytics >
      • Part 01 - Program Logic
      • Part 02 - Getting Data with SQL Queries
      • Part 03 - Automating SQL Queries
      • Part 04 - Converting SQL Results to XML
      • Part 05 - Data Processing and Manipulation
      • Part 06 - Displaying XML in HTML
      • Part 07 - Auto Updating Displayed Data
      • Part 08 - Hosting Webpage with an Existing Apache Installation
      • Part 09 - Running Multiple Queries In Sequence
      • Part 10 - Calculating Data Trends
      • Part 11 - Making It Modular
    • Windchill Quick View
  • Reviews
  • Music
  • Contact

Finding Duplicate Files with PowerShell

8/28/2016

5 Comments

 
Picture
If you are like me, you create a lot of backups.  My most common backups are cutting and pasting every recognizable file that I may have created onto an external drive before routinely reinstalling Windows.  This often leads to me having many copies of the same file in multiple drives and folders.  I needed a way to scan for all duplicate files so that I could finally consolidate my backups into having unique files only.


Read More
5 Comments

How to Convert Any Office File to PDF with PowerShell

6/16/2016

4 Comments

 
In this case, "Any" = Word, Excel, PowerPoint, Publisher, and Visio.

Now that that is out of the way, my Doc2PDF script will:
  • Detect whether you have given it a file or directory
  • Convert that single file or all files in a directory and all subdirectories to PDFs

It is very easy to use.  Please leave me feedback if you found it useful.  Download from below link.

https://github.com/escottj/Doc2PDF
4 Comments

How to Add a Cover Page to Word with PowerShell

6/14/2016

1 Comment

 
Picture
​I needed to add a cover page to many documents and decided to automate the process with PowerShell.  The real issue was to only add a cover page if one doesn't already exist.

Read More
1 Comment

Excel PowerShell Reference

6/6/2016

0 Comments

 
Hello Internet!

I have decided to showcase various snippets of code for working with Excel in PowerShell on its own page here Excel PowerShell Reference.  The purpose of this is to give you the power to create your own automation scripts by putting together the various working pieces on that page.

This blog will remain the place to go for full working examples of solutions to slightly more complex problems.

Happy Scripting!
0 Comments

How to Convert Word Documents to PDFs with PowerShell

6/5/2016

2 Comments

 
Picture

I needed a way to generate PDFs of Word documents automatically for a custom Office worker I was making for Windchill.  The following script will show you the core code to due such a thing.

Read More
2 Comments

How to Add a Signature Image to a Word Document with PowerShell

6/5/2016

0 Comments

 
Picture

Adding your signature to digital documents isn't too difficult to do but what if you need to automate the process in a certain PDM/PLM system?  This PowerShell script is the snippet of code I used to auto sign documents during Windchill publishing.

June 8, 2016: Updated to 1.1 with auto image resize.


Read More
0 Comments

How to Watermark Word Documents with PowerShell

6/4/2016

3 Comments

 
Picture

A simple script that automates the watermarking of documents in Word.

Read More
3 Comments

    Author

    PLM engineer while "on the clock", programmer, designer, dreamer all other times.

    Archives

    August 2016
    June 2016

    Categories

    All
    Cover Page
    Excel
    Office
    PDF
    PowerShell
    Reference
    Signature
    Watermark
    Word

    RSS Feed

Copyright © 2018 Erick Johnson
  • Home
  • Blog
  • Apps
    • Mortgage Calculator
  • PowerShell
    • Blog & Examples
    • Excel Reference
  • Windchill
    • Document Exporter
    • Document Worker
    • E.P.L.E.S.
    • Export Released
    • Property Checker
    • Windchill Business Analytics >
      • Part 01 - Program Logic
      • Part 02 - Getting Data with SQL Queries
      • Part 03 - Automating SQL Queries
      • Part 04 - Converting SQL Results to XML
      • Part 05 - Data Processing and Manipulation
      • Part 06 - Displaying XML in HTML
      • Part 07 - Auto Updating Displayed Data
      • Part 08 - Hosting Webpage with an Existing Apache Installation
      • Part 09 - Running Multiple Queries In Sequence
      • Part 10 - Calculating Data Trends
      • Part 11 - Making It Modular
    • Windchill Quick View
  • Reviews
  • Music
  • Contact