LazerWire

Technology and software development

About Me

Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Home
Subscribe to: Posts (Atom)

Search This Blog

Popular posts

  • Excel VBA: Download files from the Internet
    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...
  • Excel VBA: Get all selected rows
    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 whe...
  • MS SQL: Create Date
    There is no straight forward function in Transact-SQL to create a simple date based on year, month and day. Below we have created a userdefi...
  • Excel VBA: Display the Developer Toolbar or Ribbon
    By default the developer toolbar or ribbon (depending on the Excel version) is hidden in Microsoft Excel. In Excel 2007 and later it can b...
  • Excel VBA: Adding custom Button to the Toolbar or Ribbon
    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 noti...
  • MS SQL: First Day of Week
    In Transact-SQL the first day of week can be calculated based on the @@FirstDay system variable. The variable will return different values ...
  • Excel VBA: Adding custom buttons to the Right-Click popup menu
    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 Comman...
  • MS SQL: Day of Week
    The day of week for a given date can in Microsoft SQL server be calculated based on the @@ FirstDay system variable and the datepart funct...
  • Excel VBA: Sum Values IF
    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. Th...
  • MS SQL: Store Color (ARGB) as integer
    The most common way is to store colors in a SQL database as a string, i.e. the HTML color code (ex. #FFFFFF). The colors can also be stored ...

Blog archive

  • ▼  2011 (35)
    • ▼  November (7)
      • Excel VBA: Display the Developer Toolbar or Ribbon
      • Visual Studio 2010: Debug the .NET assemblies
      • Excel VBA: Adding custom Button to the Toolbar or ...
      • Excel VBA: Adding custom buttons to the Right-Clic...
      • Excel VBA: String Format
      • Excel VBA: Download files from the Internet
      • Excel VBA: Re-throw error/exception
    • ►  October (28)

Followers

Pages

  • Start
  • About Me
  • Directories

Sites

  • ImagePrint - Print Photos at Home
  • Coragi

Labels

  • .net (7)
  • 2003 (1)
  • 2007 (1)
  • 2010 (1)
  • api (1)
  • argb (1)
  • array (1)
  • asp.net (3)
  • assembly (1)
  • atomic (1)
  • bandwidth (1)
  • blogger (1)
  • blogspot (1)
  • button (1)
  • C# (3)
  • calendar (2)
  • certificate (1)
  • code (3)
  • codeplex (1)
  • color (1)
  • constant (1)
  • convert (1)
  • cron (1)
  • css (1)
  • date (8)
  • dateadd (5)
  • datediff (4)
  • datefirst (1)
  • datepart (1)
  • datetime (8)
  • day (2)
  • dayofweek (3)
  • debug (1)
  • decompile (1)
  • design (2)
  • developer (1)
  • development (2)
  • download (1)
  • e-mail (1)
  • encode (1)
  • error (1)
  • excel (11)
  • exception (1)
  • facebook (3)
  • facebook app (3)
  • firstdayofweek (1)
  • fn_varbintohexstr (1)
  • format (1)
  • free (3)
  • free ssl (2)
  • function (6)
  • google (1)
  • group (1)
  • hash (1)
  • HashBytes (1)
  • hashing (1)
  • holdlock (1)
  • hostgator (1)
  • hour (2)
  • ie (1)
  • insert (1)
  • internet explorer (2)
  • ix web (1)
  • java (2)
  • javascript (1)
  • linux (1)
  • lock (1)
  • MAPI (1)
  • md5 (1)
  • microsoft (19)
  • microsoft excel (1)
  • microsoft office (1)
  • minute (2)
  • month (2)
  • MS SQL (11)
  • october 1st (1)
  • office (3)
  • options (1)
  • outlook (1)
  • php (1)
  • picture (1)
  • png (1)
  • procedure (5)
  • programmer (1)
  • programming (19)
  • query argument (1)
  • range (1)
  • reflector (1)
  • rendering (1)
  • rgb (1)
  • ribbon (3)
  • row (1)
  • rowlock (1)
  • scheduled task (1)
  • scheduling (1)
  • schemabinding (1)
  • SDK (1)
  • second (2)
  • selection (1)
  • shared hosting (1)
  • SP (1)
  • split (1)
  • SQL (14)
  • SQL Server (5)
  • ssl (1)
  • StartCom (1)
  • storage (2)
  • string (2)
  • stringbuilder (1)
  • substring (1)
  • sum (1)
  • SVG (1)
  • table (1)
  • template (1)
  • time (5)
  • toolbar (3)
  • transact-SQL (9)
  • transaction (2)
  • transparent (1)
  • UDF (8)
  • ui (1)
  • update (1)
  • updlock (1)
  • upsert (1)
  • url (2)
  • url decode (1)
  • url encode (1)
  • userdefined (6)
  • variant (1)
  • vba (10)
  • visual basic (1)
  • visual studio (3)
  • web (5)
  • webclient (1)
  • webdesign (1)
  • webhosting (4)
  • weekday (1)
  • windows (3)
  • wininet (1)
  • workbook (1)
  • worksheet (1)
  • year (2)
Simple theme. Powered by Blogger.