Spreadsheet Budget Launched

This first version is pretty basic – yet powerful. It will import your financial data from KMyMoney (I’ll add more financial programs later). Soon I will add report templates so you can easily view your finances – how you like it. It comes with an auto updater (wyUpdate) so you can stay up to date […]

Posted in Spreadsheet Budget. Tags: , . Comments Off »

Bit Torrent Sync & Updating/Installing Programs

Bit Torrent Sync (BT Sync) is great software which can be used for syncing files. I use it for backing up all my pictures/videos/music/files/mobile computers. Well, I did some testing and it looks like it can be used for installing and updating software also. I tested it with my Windows 8 computer over to my Windows […]

Posted in excel vba, Programming. Tags: , , , . Comments Off »

Zipping Files with VBA and USB Drives

I used Ron de Bruin’s file zipping (and sending) code with Excel. It works great with a few tweaks. Unfortunately when someone is using a USB drive with their workbook on it it fails to work. So warning: Make sure the users are using it on the main computer when trouble shooting!

Posted in excel vba. Tags: , , . Comments Off »

SUMIFS vs MATCH & INDEX

I have one Time Card template setup with SUMIFS (used for Excel 2007 and above templates) and one set up with MATCH/INDEX (used for my 2003 and below templates). I tested the calculation speeds for each in Excel 2013 (preview) on Windows 8. Here’s the VBA test code: Sub test()   Dim dTimer As Double […]

Posted in excel vba, Time Card. Tags: , , , . Comments Off »

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 […]

Posted in Time Card. Tags: . Comments Off »

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 […]

Posted in C#.NET. Tags: , . Comments Off »

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 […]

Posted in C#.NET. Tags: , . Comments Off »

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 […]

Posted in Time Card, VB.NET. Tags: , , , , . Comments Off »

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. […]

Posted in Uncategorized. Tags: . Comments Off »

AdvancedFilter Wrapper Update & Bug Fixes

Apparently there are some differences between the interaction between .NET and Excel vs VBA and Excel. In .NET I use a String matrix to set the value of the criteria range and it correctly puts formulas in where there should be formulas, etc. But when I do that with VBA it enters them as a […]

Posted in AdvancedFilter, excel vba. Tags: , , , . Comments Off »