VSTO & .NET & Excel

September 29, 2008

Everyone or Just Me?

Filed under: .NET & Excel, COM Add-ins, Tools, VSTO & Excel — Dennis M Wallentin @ 12:28 am

When we install new software we usually are given the options to either install it to “Everyone” or “Just Me”. Under normal conditions this is not an issue but suppose that we only want to install the software to either the person (“Just Me”) who installs it or to everyone who will be using the computer?

In the first case, i.e. “Just Me”, it’s rather easy to solve it when using the Windows Installer. What we need to do is to set the property InstallAllUsers to False in the User Interface Editor

To change this setting we first select the Setup’s root node in the Solution Explorer, right click on it and from the menu select the command View > User Interface. In the editor’s window right click on the Installation Folder under the root node Install. Right click on it and from the menu select Properties Window. The following screen shot shows that the property’s value is now set to False:

 

Save and rebuild the Setup project. When running the Windows Installer the output of the above actions is that the software will only be installed to the person who installs it, i.e. “Just Me”. The following screen shot shows how it looks when we have removed the “Everyone” option. In other words no visual options are available:

Of course, we need also tp update the settings accordingly in the Registry Editor so it reflect the visual design.

In the second case, install to everyone who use the computer, it’s more difficult to hide the option “Just Me”. At least, I have not yet find an easier way. The tool that comes to our rescue again is Orca (see UAC Compliant and The Orca Tool – A MSI Creator and Package Viewer). With Orca we can view the Setup package and also change the required settings.

I will not in detail describe the process as it is already documented by MSFT in their KB article 835460 – How to use the Orca database editor to remove the “Everyone” option and the “Just me” option from a Windows Installer package that you created by using Visual Studio .NET. Yes, that’s an impressive long title!

Kind regards,
Dennis

Learning LINQ

Filed under: .NET & Excel, COM Add-ins, SQL Server, Tools, VSTO & Excel — Dennis M Wallentin @ 12:27 am

At present my time table does not permit me to explore new things so I have postponed delving into some areas to the next year.

However, in some cases I have made some research to get access to interesting sources and tools which I hope will help me out. LINQ is one area that is of high interest which may replace SQL within the foreseeable future. VS 2008 is the first development suite that includes LINQ.

The Book
I prefer books that target one specific area and the book LINQ in Action seems to fit in well. Actually, the book has its own site and it is also available as a PDF ebook. For more information please see LINQ in Action

The Tool
The tool LINQPAD seems to be very useful to learn and manage LINQ. It may also be more promising as it also is available for free. You can visit its homepage at the following URL: LINQPAD

The developer of this tool, Joseph Albahari, is also one of two authors of the book C# 3.0 in a Nutshell which is highly recommended if we want to learn C# together with another book, Programming C# 3.0.

Please feel free to comment available sources about LINQ as well as tools for learning how to use it.

Kind regards,
Dennis

Blog at WordPress.com.