Eventually I hope to make this a tip, but it's certainly more of a Windows how-to than anything to do with Vim. It's to solve a problem I stumbled upon at work because I'm one of very few that actually use Vim, however, so maybe it's relevant.
Please feel free to edit/comment as you see fit even though this is a user page for now.
User-specific Windows file associations
Windows file associations (which allow you to double-click on a file and have it open in your chosen application) can be set in several ways, including command-line tools such as ftype and assoc, the "Open with..." menu, and hidden in the "Folder Options" on Windows XP. Unfortunately, all of these tools apply your associations system-wide. This means that if you are on a multi-user system, and you are the only user using Vim, other people will get very annoyed if you use these tools to make files launch in Vim.
Luckily, although Windows does not provide a GUI or even easy command-line tools to edit or change it, Windows 2000 and above provide a place in the registry that can be used to store user-specific file associations. This place is HKEY_CURRENT_USER\Software\Classes. Creating a file association here uses two steps. For an example, we will associate the ".c" extension to the "sourcecode" filetype, and then tell Windows to launch anything in the "sourcecode" filetype in gvim version 7.2. It should be easy to adjust this as desired.
Step 1: associate the file extension with a file type
To do this, you need only create a registry key with the name of the file extension desired and a default value of the filetype you want to associate with it. For our example, you would create the key, HKEY_CURRENT_USER\Software\Classes\.c (using regedit or the command-line "reg add" command). In regedit, you can see a (Default) value for this key after creating it. Set the value to sourcecode.
Registry entry for file extension association
Step 2: associate the filetype with gvim
The next step is to tell Windows what to do with your new filetype. You use the same registry area for this, but it's a little more complex.
First, create the key HKEY_CURRENT_USER\Software\Classes\sourcecode\shell\open\command. This key will also have a (Default) value, which you need to set to the program used to open files of this type. For example, you could set it to "C:\Program Files\Vim\vim72\gvim.exe" --remote-tab-silent "%1" to open .c files (and other sourcecode typed files) in a new tab in the default gvim.
Registry entry for filetype action
For other file types (htmlfile for example) you may not want to open the file in gvim when you double-click, but instead when you edit the file by right-clicking and choosing, "Edit". You can do this by replacing the "open" in the key path given above with "edit". For example, for the sourcecode file type just created, you would accomplish this using the HKEY_CURRENT_USER\Software\Classes\sourcecode\shell\edit\command key.
Scripting the additions
Windows does provide a command-line utility for editing the registry: reg add. You can use this tool from a CMD prompt, but it is probably more useful to create a batch file containing commands to set all your desired file associations.
You need to escape double-quote characters with a backslash (which is weird, the usual Windows escape character is "^"...I plan to investigate eventually). To set the (Default) value we need, provide an empty string as the value name using /v "". In a batch file, you also need to escape the '%' character with a second '%' character. With this in mind, the following lines in a batch file will set up the file association given in our example above:
reg add HKCU\SOFTWARE\Classes\.c /v "" /t REG_SZ /d "sourcecode" /f reg add HKCU\SOFTWARE\Classes\sourcecode\shell\open\command /v "" /t REG_SZ /d "\"C:\Program Files\Vim\vim72\gvim.exe\" --remote-tab-silent \"%%1\"" /f
Should also mention creating and merging a reg file, which is probably easier. Associate vimprojects file with vim does this, but not in a user-specific manner.