Deployment Tips – Extracting All Microsoft Office Updates in a Folder

Because you may need to create a new source installation of your Microsoft Office and gather all the necessary security updates, here’s a quick tip extract all *.exe Office updates to the Updates sources folder.

This is particularly useful because most of the time you’ll download the updates on *.exe format and has you may know, the automated install will look for *.msp files inside the Updates folder instead.

So, here are the necessary steps to do it:

For this example we’ll use the folder D:\Temp\10\Office where you’ll put all your downloaded *.exe files and you should create also D:\Temp\10\Office\Updates where the files will be extracted.

1. Download all your *.exe files and move them to D:\Temp\10\Office
   
   
2. Open a command-line as Administrator
   
   
3. On the command-line, navigate to D:\Temp\10\Office
   
   
4. Know just execute the following command:
   for %g in (D:\Temp\10\Office\*.exe) do %g /extract:D:\Temp\10\Office\Updates /quiet
   
   
5. All *.msp files will be extracted to D:\Temp\10\Office\Updates and now you just need to copy them to your “OfficeSource\updates”.

And you’re done!

Windows 10 Creators Update–Enabling touch-friendly File Explorer

We may probably see this on future Windows 10 releases, specially for those on Windows Insider Program, but until than…

If you’re using Windows 10 Creators Update (or in other words Windows 10 version 1703) on a tablet or a 2-1 device, or simply because you’re curious about this tip, here are the necessary steps to enable a much touch-friendly File Explorer:

1. Create a new shortcut on your desktop (Right-click > New > Shortcut)
   
   
2. Now just copy-paste the following path:
   explorer shell:AppsFolder\c5e2524a-ea46-4f67-841f-6a9465d9d515_cw5n1h2txyewy!App
   
   
3. Click Next
   
   
4. Give the desired name to your shortcut
   
   
5. Click Finish

And…you’re done and can now enjoy the touch-friendly File Explorer!

Scripting - Merging multiple txt files in one

Here's a nice, quick and simple tip if you need to merge multiple text files (*.txt) in just one:

1. First put all your txt files in a folder (for example D:\Temp)
2. Now open command line and navigate to D:\Temp
3. Next, type the following command:
   for %f in (*.txt) do type "%f"  >> output.txt
4. And...it's done!