Need to know how to delete duplicates in Excel 2013? Well, thank you Microsoft! I bet a million hours have been spent over the past 10 years where people did nothing but remove duplicate rows from a Spreadsheet. Microsoft has just improved the GDP of the US by .0001% with a single Feature. The Remove [...]
How to Make an iOS Demo Screencast Video for Your App
by byron on April 13, 2013 in Miscellany
Just so you know, this is AWESOME!! You’ve worked hard to make your App great. It’s on the App Store, and now you’re ready to showcase it with a demo video. You start out with the iPhone or iPad Simulator, but that’s really limiting. You’ve got photos and maps and other stuff that just aren’t [...]
Coinshooter – iPhone App for Metal Detecting
by byron on January 25, 2013 in iOS, Metal Detecting
While this is not a Metal Detecting blog, I do capture my iPhone exploits here, so this is mostly relevant I’ve just released my 5th iPhone app, and the one that I am most excited about. I’m probably always excited about the newest one, but this one really solves a specific set of needs for [...]
So long, and thanks for all the Search!
by byron on July 3, 2012 in Google
Google has announced iGoogle’s demise. iGoogle and the excellent, unified search/address bar in Chrome were the two primary ways I interacted with Google. Google even gave me a friendly note on my iGoogle page about the November 1, 2013 doomsday, advising me to pack my bags early and be on my way to greener pastures. Why, [...]
Mac OS X – Working with NSImage, Core Data, and Address Book
by byron on April 9, 2012 in Cocoa, Mac, Programming
Sorry this isn’t in tutorial format, but I want to capture this so I don’t have to search quite so long next time ! While I’ve done several iOS apps, I’m getting started on my first Mac app. If you’ve spent a year or so with iOS and you think that jumping to the Mac’s [...]
C# – NullReferenceException with TableAdapter and Scalar Values
by byron on December 6, 2011 in ASP.NET/C#, Programming
Ok, I’ve been hacking around this particular problem for a month now, but think I’ve got a bead on how to stop it. So, I hope this helps someone! The Situation I’ve got a TableAdapter in C# and I’m using a Query to return a scalar value that ultimately becomes a double data type. The [...]
iOS 5 – Problem Setting an Image for UINavigationBar Background
by byron on December 3, 2011 in iOS
iOS 5 has made it much, MUCH easier to set an image as the background of your UINavigationBar. There are dozens of tutorials out there that will get you there, and I tried a half dozen of them, but still couldn’t get it to work. The code itself is very simple, and here it is: [...]
C# / VSTO – Using Excel Ranges
by byron on November 28, 2011 in ASP.NET/C#, Microsoft Excel
Using Visual Studio Tools for Office (VSTO) with Excel lets you use C# (or your other favorite .NET language to leverage the power of Excel. But you will have to learn how the syntax for the Excel object model as opposed to just using VBA syntax. This post shows you how to use Excel ranges [...]
C# – VSTO – Get Last Used Row or Cell in Excel Spreadsheet
by byron on October 25, 2011 in ASP.NET/C#
I have had the opportunity to get my fingers dirty with Visual Studio Tools for Office, at long last. My project brought me back to an old familiar problem in Excel, finding the last used row in a spreadsheet. This applies equally to C#, VB, and VBA. You just have to get access to the [...]
SAP – AUTH – How to Find Users who have Access to a T-code
by byron on August 15, 2011 in SAP
In the Business Analyst role in an SAP shop, it may be helpful to know what Roles or Users have access to a particular transaction code. Here’s a little tip that lets you do all sorts of queries about the authorizations in your SAP system. Use T-code: AUTH to Access “Infosystem Authorizations” Menu To get [...]
Recent Posts
Popular Posts
- Excel Spreadsheet of US States
- Get ASP.NET DropDownList Selected Value with jQuery
- Javascript: How to get an Object's ID
- ASP.NET - Get User Name Under Windows Authentication
- WordPress: Get Category ID for a Category Page
- PHP: What is the & Ampersand Preceding Variables
- C# - Get a Random Number Between x and y
Tags
Categories
- Accounting (1)
- adobe air (1)
- ASP.NET/C# (16)
- Blogging (8)
- Books/Movies (1)
- Cocoa (1)
- Food/Travel (1)
- Google (2)
- iOS (4)
- iTunes/iPod (1)
- Javascript Frameworks (3)
- jQuery (3)
- Mac (5)
- Metal Detecting (1)
- Microsoft Excel (8)
- Microsoft Outlook (1)
- Miscellany (14)
- PHP (8)
- Productivity (6)
- Programming (8)
- SAP (52)
- Software (2)
- SQL (2)
- Web (5)
- Web Development (13)
- WordPress (18)
- WordPress Plugins (3)
- WordPress Themes (3)
- Words/Quotes (1)
- Worksoft Certify (6)
- YouTube (2)


