Tuesday, May 28, 2013

How to unlock and remove passwords on XLS/XLA 2003 files


  1. Use a Hex editor to open the XLS file 
  2. Search for "DPB="
  3. Edit "DPB=" to "DPx="
  4. Save the XLS file from the Hex editor
  5. Open the XLS file, Excel should throw up an error saying " Do you want to continue loading the project?" Click
  6. Press ALt+f11 and go the the properties of the VBA code and tyep a new password. 
  7. Save the XLS file
  8. Close and re-open the XLS file

Notes:
 This only works for XLS 2003 format files. This process will not work in Office 2007/2010 documents

If you find this article useful please leave me a comment or click on an ad to show your support.

Friday, May 24, 2013

Random network dropouts on Lenovo T410 and X201

I was getting random network dropouts on X201 and T410 Lenovo laptops. Throughout the day users would report  that the NIC simply dropped. Rebooting fixes the issue in most cases.

Turns out both these models use the same hardware "Intel 82577LM" so something is up.

I compared settings to various other network cards and found the only real difference was that the 'receive buffers' were set to '80'.

Setting the 'Receive Buffers' to '256' seems to fix the dropout issue. 
If you find this article useful please leave me a comment or click on an ad to show your support.

Friday, May 03, 2013

PowerTip: Use PowerShell to Show Remaining Battery Time - Hey, Scripting Guy! Blog - Site Home - TechNet Blogs

Show the remaining battery charge (Percentage) using PowerShell.
(Get-WmiObject win32_battery).estimatedChargeRemaining
Want to know what other properties can be looked up?
Get-WmiObject win32_battery | Get-Member
Quick Tip: Win32_Battery class only works if you have a battery in the system to report on (i.e the above code will work on laptops not desktops)


PowerTip: Use PowerShell to Show Remaining Battery Time - Hey, Scripting Guy! Blog - Site Home - TechNet Blogs: "(Get-WmiObject win32_battery).estimatedChargeRemaining"

'via Blog this'