I am used to viewing files in different windows and when I found Excel forcing me to view two spreadsheets inside the same MDI form I looked for an alternative.

Realistically I thought that an option would be available allowing me to choose how Excel opened multiple documents but I was wrong.

If you want to open two Excel files in different windows for whatever reason, you need to modify the File Association actions.

Since I use dual monitors on a daily basis, this "fix" is a must in order to take advantage of having a dual display.

The answer can be found in the following article: Open Excel in Different Window

AR

Sometimes for security reasons you will want to clear usernames, passwords and even IP addresses or hostnames after using RDP/RDC Terminal Services Client in Windows XP.
  This is especially prevalent in companies where employees have some knowledge in the area.

You can customise the connection properties individually by using the "Options" part of the RDC Dialog box. Once you've selected what you want the connection defaults to be, you can use "Save As..." to save a different copy for each of your connections.

So when clearing up your connections, simply delete these ".rdp" files to clear your settings.

That is however only step one.

A default.rdp file is saved in "My Documents" once you have used the RDC Client on your machine. You will also want to delete this file. That's step two.

However, when you go back into the RDC Client you see that the IP addresses or hostnames are still there. Worse still, usernames are suggested when you try to connect to one of these hosts.

As usual, the information we want to remove is stored in the registry. Not in a difficult to find or particularly dangerous part either.

So step three is to modify the registry. Remember that you do this at your own risk... yadi-yadi-yah.

Clear (delete) the MRU's in the following key (these are the hosts):
HKEY_CURRENT_USER\Software\Microsoft\Terminal Server Client\Default

Clear (delete) the username hints in the following key:
HKEY_CURRENT_USER\Software\Microsoft\Terminal Server Client\UsernameHint

That should then clear the history of your Remote Desktop Connections.

Ever got this dialog box: "the project location is not trusted" ??

Yeah me too. A recent change in network infrastructure and folder-redirection caused this issue to surface.

The way around it is well documented but sometimes there are other factors to consider.

First, take a look at Microsoft's fix for this: The Project Location is Not Trusted Dialog Box

Then if you still have a problem like I did, check the location is not in your Trusted sites list in IE (thanks to the following page: http://discuss.joelonsoftware.com/default.asp?dotnet.12.334487.2

I know the author of that page didn't solve all his problems but removing the network location from my Trusted Sites list sorted out my problem straight away.

AR

I haven't updated my website much lately - guess I've been really busy at work. I'm currently working on some Server 2003 projects and have been playing around with Group Policy, roaming profiles and redirected folders.

These are not new subjects to me but as I tend to do more development work nowadays, it usually means long periods between server work and the things you don't do every day fall out of your memory.

I had a real grapple with what I initially thought was permissions issues the other day but turned out to be caused by poor allocation in Server 2003 by default.

The situation arose when I was trying to get client machines to create and update roaming profiles (all done in a test environment before going live). The actual error condition was "Not enough server storage space available to process this command" and after trawling about I found the fix to be something going back to Windows NT times and a resistry hack to enable or increase the IRPStackSize. Updated the registry and the problem was solved.

The fix is available here: IRPStackSize Registry Fix

AR

This is a simple application that allows you to filter individual lines out of numerous files in a single directory. I have found uses in cleaning dictionary files where US words have crept in.

It could be equally useful in removing anything that exists on its own on a single line. Simple provide the path containing the data files to clean and then select the file that contains each erronious entry.

Download from here: Filter Software

Thanks,

AR