2012-04-19 08:08
If you're enjoying the martial arts (karate, tae kwon do, judo, etc.) you should share your fighter profile with your friends on Facebook using the new My Fighter Profile app. You can share… Read More
Blog Directory > Arts & Entertainment Blogs > LazerWire.com arts-and-entertainment Blog >
Lazerwire.com Blog
lazerwire.blogspot.com
Tags:
string
excel
source code
error
code
net source code
popup menu
developer
error resume nextset
reflector
Technology and software development
2011-11-16 14:57
By default the developer toolbar or ribbon (depending on the Excel version) is hidden in Microsoft Excel. In Excel 2007 and later it can be quite tricky to figure out where to enable the dev… Read More
2011-11-07 19:55
The .NET framework is under heavy development and bugs are removed by Microsoft developers when found. However, you may still experience major bugs that might cause your application to crash… Read More
2011-11-07 19:53
When writing a blog related to programming it is quite tricky and troublesome to format the source code in a readable way. That is why we need pretty-formating tools. The following sites off… Read More
2011-11-07 19:25
Custom buttons are added to the toolbars or ribbons when a Microsoft Excel sheet is opened, and removed when the sheet is closed. To be notified when a given Excel sheet is loaded we ne… Read More
2011-11-07 19:15
In Microsoft Excel it is possible to extend the right click popup menu by using VBA. The right click menu is implemented as a special CommandBar (like the toolbars in Excel 2003) with the na… Read More
2011-11-01 18:36
The functions string.Format or StringBuilder.AppendFormat are two very usefull functions for formatting strings and increasing the readability of your .NET code. The Format function in VBA u… Read More
2011-11-01 17:33
There is no built-in function in Microsoft Excel which allows you to download contents from the Internet on the fly. To accomplish this task we need to use the API for WinInet. The use and e… Read More
2011-11-01 17:04
The current version of Microsoft Excel does not support the new Try/Catch blocks found in VB.net or any other modern programming languages. To handle errors within a procedure the "On Error… Read More
2011-10-23 07:53
.NET Reflector is dead, long live ILSpy. Well, .NET Reflector is not really dead, as you might already know, but you now have to pay if you want to use the disassembler. Below we have listed… Read More
2011-10-23 07:09
Often I have the need to parse the URL query to retrieve the value of a specific named argument. There is no direct way of doing this is JavaScript, so this requires a custom function.functi… Read More
2011-10-10 18:44
Below we have made a function which sums the values of one column/range given that the value of another column is equal to a fixed value. This function ignores the N/A values, which is not t… Read More
2011-10-10 18:36
To simplify the conversion of a variant array to a string array we have made a set of utility functions.' Array Variant to StringPublic Function VariantArrayToStringArray(ByVal arrVariants A… Read More
2011-10-10 18:28
In Excel it is possible to group rows and columns. To expand or collapse a a group you can use the VBA method called ShowLevels. In the example below we are expanding a row group… Read More
2011-10-10 18:13
If the user does does a selection of rows in Excel, the selection can contain multiple areas. An area is a subselection of rows created when the user presses the Shift button while doing a m… Read More
2011-10-10 17:36
There are several ways to send e-mail from Excel using Microsoft Outlook. It is possible to use the built-in function ActiveWorkbook.SendMail. However, it only allows simple e-mails to be cr… Read More
2011-10-08 17:30
Want to have a proffessional looking blog on blogger.com (blogspot.com)? The available templates for blogs on blogger.com are very limited. You can download free templates from the following… Read More
2011-10-08 17:06
If you're a student and want to learn Facebook App development, or just need a free webhost for your app, you can apply for free webhosting from numerous free webhosting providers. If you ar… Read More
2011-10-08 16:42
Believe it or not, it is possible to host your ASP.NET application for free. Storage, bandwidth, etc. is of course limited, but it is a good offer for students and test applications.Below we… Read More
2011-10-08 15:48
When first deciding to create a Facebook App in ASP.NET I was struggling to find a up to date Facebook SDK for .NET. Some of the SDKs contains very low level functions, while… Read More
2011-10-08 14:32
Versions prior to Internet Explorer 7 has limited support for transparent PNGs. To enable transparent PNGs in IE 6 you should use the following statement in your CSS:<!--[if lt IE 7]… Read More
2011-10-08 14:23
After hours of searching for code for rendering SVG pictures I finally stumbled upon the SVG rendering engine at Codeplex. The good thing about SVG is that it is supported in most modern bro… Read More
2011-10-08 14:03
If you choose to run your website in a shared hosting environment on windows servers, most webhosts don't allow you to schedule your own tasks, like backup, changing status etc. If you run p… Read More
2011-10-08 13:33
Transact-SQL really lack a the neccessary support for creating and modifying dates and times. Now and then I have the need for creating custom dates based on year, month and day. This is not… Read More
2011-10-08 13:00
To create a full DateTime structure in Transact-SQL we need to use two of our earlier defined userdefined functions. First we generate a raw base date, and then we add the hours… Read More
Subscribe to Lazerwire.com
Get updates delivered right to your inbox!