Recent content by Aptitude

What is ExcelHelper? I am guessing the the bug is in its TerminateExcel function. I am going to guess this is uesd to get around the issue with COM Reference counting. For a full explanation take a look at this Microsoft Knoledge Base Article Office application does not quit after automation...

Most controls have a TabStop property. Simply set this to false.

It sound's like that shouldn't be happening. You should be able to open two separate Excel files at the same time and not have them interfere with each other. How exactly are you opening and closing the files? Would it be possible for you to give us a couple of short code snippets?

Given that there a a huge number of ways the excel file could be open before your open file dialog is run I don't think blocking the open menu item is going to solve your headaches. The best thing to do is to check if the file is already open when you open it and display a dialog to the user...

It goes something like this assuming a table with three columns called ID, Column1 and Column2: Try connection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db1.mdb") connection.Open() Dim command As New OleDbCommand()...

Just out of interest, why do you want to do that?

The only thing you seem to get from using the GAC is a reduction in hard disk space when multiple applications use the same dlls. But why bother when 100Gb disks are so cheap. On the flip side with the GAC you get a big headache when it comes to deployment. Using the GAC you can no longer...

There are lots of possibilities for this. Can you tell us what your application is going to do? It might give us a clue as to what the appropriate answer to this is.

I'm supprised no one has mentioned Visual Studio here yet.

Another way to do this is to use the regular expressions exec function to get an object containing an array of matches. This requires the regular expression engine to do a little less work than using replace. function test() { var input = "FAX: 111.222.3333"; var re =...

I assume you are using a System.Windows.Forms.Timer control. This control uses Windows Messages to launch the Tick event and as such the tick will always be on the UI thread. To get each tick to be on a separate thread you would do the following but be warned if the UI thread is busy when the...

And yet another way to do this: string str = @"He yelled """ + intYear.ToString() + @""" at the top of his voice.";

It may be that your connection to VSS is a touch slow, or your solution is very big. What is happening is that Visual Studio is doing its status checks in the background. This enables you to get working on your project quicker because you don't have to wait for the status checks to be performed...

I've just noticed something rather annoying about custom error pages. Wanting to show users a nice message when they try to load a non-existent aspx page I set my web.config up like this: <configuration> <configSections> <system.web> <customErrors mode="On"...

Adamroof, That looks like just what I was looking for. And only $39 too. I never thought to use Flash!