Updating URL Hyperlinks within Excel

Recently I had an issue where a user moved a spreadsheet that contained hundreds of hyperlinks to files stored on the server. Obviously once moved none of the links worked and I was tasked with trying to change all these links without spending weeks doing it manually. The only real option is to create a… Read More »

Set Out of office for multiple users

If you need to set the out of office for multiple users you can use a powershell script Set-MailboxAutoReplyConfiguration ALIAS -AutoReplyState scheduled -StartTime “07/12/2013 14:05:00” -EndTime “08/05/2013 08:00:00” -ExternalAudience all -InternalMessage $oof -ExternalMessage $oof where the variable $oof is a predefined message. $oof = “I’m not in the office currently” Here I’ll give a more… Read More »

A simple VBS script to change IE Proxy Settings

I give this script to remote users so they can remove the Proxy settings when off site. set WshShell = CreateObject(“WScript.Shell”) Const HKEY_CURRENT_USER = &H80000001 strComputer = “.” Set objRegistry = GetObject(“winmgmts:\” & strComputer & “rootdefault:StdRegProv”) strKeyPath = “SOFTWAREMicrosoftWindowsCurrentVersionInternet Settings” wshshell.run “tskill iexplore /a” strValueName = “ProxyEnable” dwValue = 0 objRegistry.SetDWORDValue HKEY_CURRENT_USER, strKeyPath, strValueName, dwValue… Read More »

Mapping Printers via OU or Computer Name

A simple script that will map printers for users based on either the computer name or OU the computer is in, very handy if users roam between computers. Create the following script, save it in an accessible share such as netlogon and set it to run as a user startup script via GPO. ‘================================================== ‘PrinterMapping.vbs… Read More »

Force Windows to shutdown at a specific time free

Forcing shutdown can be done easily by creating a scheduled task on clients issuing the shutdown command. I create these tasks with a simple computer startup script run via a GPO. BasicScheduleTaskCreator.bat REM Delete existing tasks schtasks.exe /delete /TN Shutdown /f schtasks.exe /delete /TN Log_Off /f REM Create new tasks schtasks.exe /create /SC WEEKLY /D MON,TUE,WED,THU,FRI,SAT /ST 21:00:00 /TN… Read More »

Personalize Users Microsoft office

Having problems when users try to open a office document that is already open by another user but it doesn’t show the username.  The problem usually resides around a missing registry key at HKCUSoftwareMicrosoftOfficeCommonUserInfo run the following VBS script as a logon script to set the registry key correctly. on error Resume Next const HKEY_CURRENT_USER… Read More »