Archive for category MDT2012

Adding All Excel-Addins for ALL USERS in Windows 7 [Success]

Posted by on Monday, 11 February, 2013

This really is one of the most valuable scripts I’ve ever written — not because of it’s complexity (it’s not complex) or because it’s incredibly smooth and transparent to the user (it’s neither). It’s valuable because it’s a very simple work around for a problem I’m confident Microsoft could fix — but for some reason hasn’t. And this problem has been plaguing us since the inception of Windows 7 and the inability to copy user profiles. Not a big deal if we didn’t have multi-user machines running DeepFreeze (erases all changes when someone logs in)

You may know that Excel Add-ins are added per user, in the registry. Current User, that is. I’ve tried, to no avail, modifying the HKLM keys, adding the Excel Add-ins automatically for all users. After failing too many times, I decided to simply import the HKCU regkey every time a user logs in. It’s a work around, for sure — but it WORKS and solves a problem for countless many.

In it’s simplest form — login to a computer, add the Excel Add-ins using the steps below:

Launch the registry through Start > Run > Regedit. Navigate to:

You will see several options listed as follows:
“OPEN”=”/R “C:\Program Files\Microsoft Office\Office14\Library\Analysis\ANALYS32.XLL””
“OPEN1″=”/R “C:\Program Files\Microsoft Office\Office14\Library\Analysis\ATPVBAEN.XLAM””
“OPEN2″=””C:\Program Files\Microsoft Office\Office14\Library\EUROTOOL.XLAM””
“OPEN3″=””C:\Program Files\Microsoft Office\Office14\Library\SOLVER\SOLVER.XLAM””
“OPEN4″=””C:\Program Files\Research Insight\Excel\Spri80.xla””

The goal is to get this set of registry entries to show up for every user. So we’re going to export the keys — and then import them every single time a user logins into any computer that has DeepFreeze on it.

You could simply place this exported registry key on the local hard drive and then make a batch that runs in startup and contains the following:
regedit /s “C:Program FilesMicrosoft Officeexcel.reg”

Done. It will import the new registry key for the person logging in, before they ever have a chance to launch Excel.

For me, one additional complication is that I’m doing this POST deployment of the OS which is already deepfrozen. So I instructed DeepFreeze to run a late night script during maintenance:

Run a batch file that disables User Account Control:



and then run this batch:

copy “\\networkserver\sharename\Custom\OS_Modifications\Excel_Addins\excel.reg” C:\Users\Public\Desktop
copy “\\networkserver\sharename\Custom\OS_Modifications\Excel_Addins\startup_excel_addins.bat” C:\Users\Public\Desktop
copy “C:\Users\Public\Desktop\excel.reg” “C:\Program Files\Microsoft Office” /Y
copy “C:\Users\Public\Desktop\startup_excel_addins.bat” “C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Startup” /Y
del C:\Users\Public\Desktop\startup_excel_addins.bat /Q
del C:\Users\Public\Desktop\excel.reg /Q

This copies the exported registry key from my server to the local computer desktop (Windows 7 won’t let me copy it directly to the root of C or to Program Files sometimes).  It also copies over the batch file that will ultimately be in the startup folder.

It then copies each file from the desktop to their end destination.  It then deletes the files from the desktop.  Now, with “startup_excel_addins.bat” resting in the Startup folder for ALL USERS, every time someone logs in, this batch file runs quickly and quietly to install the Excel Add-ins.  Done!

Silent install Office 2013 [Success]

Posted by on Tuesday, 6 November, 2012

The new boss is the same as the old boss:

The installation method is identical to 2010. (see above and below reference)

From this URL:

To configure silent installation and automatic activation options in the OCT

Run the OCT by typing setup.exe /admin at the command line from the root of the network installation point that contains the Office 2013 source files. For example, use \servershareOffice15setup.exe /admin.

To set silent installation options, choose Licensing and user interface in the navigation pane, in the details pane choose None in the Display level drop-down box, choose Suppress modal, clear the Completion notice check box, and then choose I accept the terms in the License Agreement.

To enter a MAK key, choose Licensing and user interface in the navigation pane, and in the details pane select Enter another product key, add your organization’s MAK product key for Office 2013 in the Product key text box.

To set automatic activation options, choose Modify Setup properties on the navigation pane, and then choose Add in the details pane.

In the Add/Modify Property Value dialog box, in the Name box, type AUTO_ACTIVATE. Note that property names must be uppercase.

In the Value box, type 1, and then choose OK.

When you complete your customizations in the OCT, click Save as on the File menu to save the Setup customization .msp file. You can save the customization .msp file in the Updates folder on the network installation point. Note that you can place only one Setup customization .msp file per product in the Updates folder for initial installations. For more information about using the Updates folder, see “Updates folder” in Office Customization Tool (OCT) in Office 2013.

Delete saved Windows 7 profiles using a wildcard via batch script

Posted by on Tuesday, 25 September, 2012

ATTRIB +H C:\Users\jhiltabidel
ATTRIB +H C:\Users\administrator
ATTRIB +H C:\Users\Public
FOR /D %%i IN (“C:Users*”) DO RD /S /Q “%%i” DEL /Q “C:Users*.*”
ATTRIB -H C:\Users\jhiltabidel
ATTRIB -H C:\Users\administrator
ATTRIB -H C:\Users\Public

Firefox 15 silent install [Success]

Posted by on Wednesday, 29 August, 2012

Honestly, pretty tired of Firefox offering a major version number update every few weeks.  Now we’re on ver. 15 and allegedly Firefox is fluidly updating itself automatically (Like Chrome does).

I install using a batch:

install_Firefox.bat, which contains this code:

“C:Program Files (x86)Mozilla Firefoxuninstallhelper.exe” /s
“C:Program FilesMozilla Firefoxuninstallhelper.exe” /s

“\servershareApplicationsFirefoxver_15Firefox15.exe” -ms
copy “\servershareApplicationsFirefoxver_15override.ini” “C:Program FilesMozilla Firefox” /Y
copy “\servershareApplicationsFirefoxver_15mozilla.cfg” “C:Program FilesMozilla Firefox” /Y
copy “\servershareApplicationsFirefoxver_15local-settings.js” “C:Program FilesMozilla FirefoxDefaultsPref” /Y
copy “\servershareApplicationsFirefoxver_15override.ini” “C:Program Files (x86)Mozilla Firefox” /Y
copy “\servershareApplicationsFirefoxver_15mozilla.cfg” “C:Program Files (x86)Mozilla Firefox” /Y
copy “\servershareApplicationsFirefoxver_15local-settings.js” “C:Program Files (x86)Mozilla FirefoxDefaultsPref” /Y

The above code references three files (twice actually — once for 32-bit and once for 64-bit.  Even though the files are unchanged from x86 to x64, the locations where they need to be copied DOES change and so I copy to both locations by default).  The three files referenced are:

1. override.ini, which contains this code:


2. mozilla.cfg, which contains this code:

//Firefox Default Settings

pref(“browser.startup.homepage_override.mstone”, “ignore”);

//disable default browser check
pref(“”, false);

// disable application updates
pref(“app.update.enabled”, false);

//use classic downloader
pref(“”, false);

// Do not redirect user to the homepage override URL
lockPref(“browser.startup.homepage_override.mstone”, “ignore”);

// The URL to use as a homepage when the browser starts after an upgrade
lockPref(“startup.homepage_override_url”, “”);

// The URL to display upon loading Firefox with a new profile for the first time
lockPref(“startup.homepage_welcome_url”, “”);

// Disables ‘Know your rights’ message on first launch
pref(“browser.rights.3.shown”, true);

// disables the request to send performance data from displaying
pref(“toolkit.telemetry.prompted”, 2);
pref(“toolkit.telemetry.rejected”, true);

// Disables popup-blocker, enabling pop-ups.
lockPref(“dom.disable_open_during_load”, false);

// Disables remembering passwords
lockPref(“signon.rememberSignons”, false);

// Disables “I am about to enter an encrypted page” warning
lockPref(“security.warn_entering_secure”, false);

// Automatically Check For Updates to: Installed Add-ons
lockPref(“extensions.update.enabled”, false);

3. local-settings.js, which contains this code:

pref(“general.config.obscure_value”, 0);
pref(“general.config.filename”, “mozilla.cfg”);
user_pref(“extensions.update.enabled”, false);
user_pref(“toolkit.telemetry.prompted”, true);

Using all of the information above and executing the batch file in whatever way you do… (for me through MDT or DeepFreeze) it uninstalls the previous version of Firefox, installs the new one and customizes the home page and other settings.

Where does it fail?  In the damn “Firefox checking for incompatible add-ons” window.  I can’t seem to force Firefox to suppress the “incompatible add-ons” warning.  Although I do not add any add-0ns intentionally, some programs (Acrobat) do.  Still, overall this deployment works sufficiently.  Users may have to close that window once when they launch Firefox… still working on perfecting it but it would help if they stopped updating Firefox.

Process Modeler for Visio Silent Install [Success]

Posted by on Wednesday, 8 August, 2012

The installer can be run using a batch file:  pm57en_14684_2010_32.exe /S /v/qn

And then this note below from their tech support regarding importing the license.  Checkout regedit /? for commands.  I import routinely this way.


You can set the license info directly to the registry with your installer.
As an example under win64 and Office2010/64 you will find the license information
under the path:

HKEY_CURRENT_USERSoftwareWow6432Nodeitp commerce Ltd.Process ModelerLicense

There you have to set Licensee and LicenseKey keys.

Best is to make a manual installation and copy this keys from there into your installer batch.

Best regards,
Information & Support

FAILURE (5456): Unable to determine Destination Disk, Partition, and/or Drive. [Success]

Posted by on Friday, 13 July, 2012

“FAILURE (5456): Unable to determine Destination Disk, Partition, and/or Drive.  See BDD.LOG for more information.”

I was only getting this message using MDT2012, not MDT2010.  After digging around I noticed a modified setting — that I did not modify.  Not sure why this happened.

Look inside the task sequence, under “Install Operating System”.  While my other task sequences are set to “Specific Disk and Partition” this one was set to “Logical drive letter stored in a variable”.  When I changed it, the error went away immediately.