Coming TimeCard Software Updates

Just a quick update. I should be putting out the new Excel Time Card by the end of this week or early next week. This will be a big update. Including the following: Dashboard redesign (and Staging Area) easily change jobs on chart easily change settings on dashboard filter jobs on chart, e.g., you have TimeCard and TimeCard:Marketing, you can just put TimeCard* to include both on the same screen The template is now included in the program, so no need to download it I'm testing out a new updater so you can have secure and smaller packaged updates. [Read More]

Excel Extensions

Excel extensions extend the range object to use LinqTo2dArray (see also Codeplex). It also includes other extensions. RowsCount: Count total rows in all areas. Parse: Parse congruent range into an object by row-object arrays. This doesn’t necessarily need to be congruent, in the future I may make it so it skips to different areas in the range. ToArray: Copies the elements of the 2D object array row wise to a new array of the specified element type and length. [Read More]

LinqTo2dArray

LinqTo2dArray written in C# (to allow iteration over the rows). Also found on CodePlex. Parse will take a 2D Array (not necessarily zero based) and load it into a class. Parse 2D object array into a class row wise. Compose will create 2D object array from enumerable type. Copies the elements of the 2D object array row wise to a new array of the specified element type and length. using System; using System. [Read More]

Attempted to Read or Write Protected Memory

I’ve been working on switching over to a “new” machine (more on that in a new post). In the process my time card program stopped working with the following error: System.AccessViolationException was unhandled Message: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. Unfortunately this error doesn’t show up until well after it occurs. So you need to make some educated guesses as to where it is coming from. [Read More]

RSS for Old Blog Posts

One of the nice to haves on my list is a way to read old blog posts via RSS. I’ve found that it is really easy to read someone’s old material on their blog if it is drip fed to me. Well, after a little searching on the internet I found Stream Spigot’s Feed Playback. Now I can enjoy someone’s old posts without having to remember to go back every other day or once every week. [Read More]

Max Write to Excel (2003) in Array

I normally don’t deal with very long strings. But I’m working on a project that requires storing a text file in Excel that I can later access (it would be nice just to embed it but Excel doesn’t like viruses – which makes me have to just store it in a worksheet). So what is the max string length in an array write to an Excel range? 911 Seems kind of random but that is the number. [Read More]

AdvancedFilter Wrapper Engine

for VBA Enthusiasts

A while back ago I promised to produce my engine for the advancedfilter wrapper. Well, at the prodding of Hugo I finally put it together. I took the code from my VB.NET project and converted it to VBA. Man, that reminds of why I love .NET so much! If you ever get a chance to learn .NET of VBA definitely take the opportunity. At first it is difficult but then it gets to the point where you don’t want to go back. [Read More]

List of Excel Functions - Code To Use List

I saw a few people were downloading my list of Excel functions that I created. I thought it might be useful show the code that I use to get that data to a manageable format. Although the code is written in VB.NET it should be easily converted to VBA. [wpdm_file id=3] I use a simple structure (type in VBA) for the data. Private Structure ExcelFunctionInfo Dim Name As String Dim Category As String Dim ExcelVersion As Integer Dim Description As String Dim Syntax As String Dim URL As String End Structure I then just loop through the data in the string that was gotten from the text file. [Read More]

Excel Queries

I came across some nice libraries to use while programming to query Excel. Right now I’m am using the standard COM interface for my projects, which is fine for small ranges (which is true for most users – I would assume). But for large ranges I would need something more powerful. LinqToExcel LinqToExcel appears to be a great project for using a Linq interface to query Excel (but not write to Excel). [Read More]

Scribble Filter Now Available and Other Muses

I got the sale software all installed so I can sell the Scribble Filter. There’s still a few changes I wanted to make with it. I wasn’t entirely thinking when I added the ability to filter ranges directly when I add (among others). I should have made it more compliant to what Microsoft does. I’ll be working on changing that around now. It will probably be a little while before I incorporate all of that into the filter. [Read More]