Remove Add-in Password

I found these steps in one of my mails. I was trying hard to remove the password for TD upload add-in when I encountered this and I kept a copy on mail (I was not blogging at that time :)) I was not aware of the OTA at that time so was very curious to look how that add-in was written. Hope this is useful in case you don’t remember the password for any of your add-in.

1. Get a binary editor. You can easily get a freeware binary editor.
2. Make a new Excel workbook, set a password in VBA Properties Dialog
3. Save the workbook as an *.xls file
4. Open the xls file with the Unknown password in the binary editor
5. Open the xls file with the password we’ve created in step 2. Also with the binary editor
6. Search using the binary editor’s in both the open files for “DPB”
7. When you find this, there wil be a code attached to this and you will also find CMG code above and a GC code beneath
8. Now all you do is to replace this section of code inr the xls file which you don’t know the password for with the password you know
9. Save the file and run Excel and open the book with the password you’ve entered in step 2
10. Always make a backup of the file with the UNKNOWN password, because editing with an binary editor can be fatal.

Test Director Access using IE7

I got my default web browser Internet Explorer upgraded to Version 7 and then realized that I am not able to access Test Director.

I can’t work without Test Director and also wanted to explore IE7 both at same time, so I was looking for options by which I can use both the applications.
After googling on this issue, I found 2 solutions

1. Install Stand-alone version of IE6 which is available here. You can also choose to install other versions of IE
2. Install TD Explorer which is an application provided by Mercury. This is usually bundled with the Test Director installation and should be available on the add-ins page. The applications looks like this

There is a workaround to use TD from FireFox but I am not able to figure how.