Monthly Archives: July 2012

stdole.dll in the GAC

Let’s say you’ve got a utility suite that uses Office Interop for a subset of functionality. Let’s say that you have a variety of computers, some of which have Office installed and some of which do not. Let’s say that you use … Continue reading

Posted in Office, Programming, System/DB Administration | Leave a comment

Office apps… interesting

http://msdn.microsoft.com/en-us/office/apps Build apps for Office and SharePoint Embracing web standards, the new cloud app model gives you maximum choice and flexibility to build a new class of apps for Office and SharePoint using familiar languages, tools, and hosting services. Visit … Continue reading

Posted in Parenting | 1 Comment

Drought Thought

“Daddy, do you know why I am sad we did not have any rain?” “No, why?” “Because I won’t ever, ever see any rainbows.”

Posted in Parenting | Leave a comment

Barcode generator / Barcode decoder

I’ve used several decent online barcode generators and decoders. These are the best I’m aware of: Generator: http://www.terryburton.co.uk/barcodewriter/generator/  Project site: https://code.google.com/p/postscriptbarcode/ Decoder: http://zxing.org/w/decode.jspx Project site:http://code.google.com/p/zxing/  

Posted in Programming | Leave a comment

Open source PPM Project Portfolio Management software

These are the Open Source PPM applications which look the most intriguing to me after a brief search/scan. Project.Net: http://www.project.net/ Projectivity: http://www.projectivity.biz/opencms/opencms/en/overview.html dotProject: http://dotproject.net/ TaskJuggler: http://www.taskjuggler.org/ (Looks an awful lot like open source MS Project) SugarCRM: http://www.sugarcrm.com/ (CRM PPM??) Reference: http://www.dreamcss.com/2009/08/11-open-source-project-management-tools.html

Posted in Project Management | Tagged | 1 Comment

C# keystroke to reformat code, align code, beautify code, update code layout, standardize code

C# keystroke to reformat code, aka. align code, beautify code, update code layout, standardize code. Standard keys: Ctrl-E, D : format entire document. Ctrl-E, F: format current selection. Code Formatting The C# code editor automatically formats code when you press … Continue reading

Posted in Parenting | Tagged , | Leave a comment

Quick-n-dirty C# Inputbox

Add a reference to Microsoft.VisualBasic. string excelFilename = “C:\\CT176YellowCards.xlsx”; excelFilename = Microsoft.VisualBasic.Interaction.InputBox( “Name of CT176 report file?”,  “Ct176 Yellow Card report question”, excelFilename, -1,-1); Reference: http://social.msdn.microsoft.com/Forums/en-US/csharplanguage/thread/ab9debc2-b355-445b-a9cb-29135f973836/

Posted in Parenting | Leave a comment

Open a file using the system-defined application

  // Open the Excel spreadsheet. string filename = “C:\FreshlyExportedSpreadsheet.xls”; System.Diagnostics.Process.Start(filename);

Posted in Parenting | Tagged , | Leave a comment

ExcelInterop.cs

  using System; using System.Collections.Generic; using System.Linq; using System.Text; using Excel = Microsoft.Office.Interop.Excel; using System.Reflection;    //Missing.Value using System.Windows.Forms; //Messagebox   namespace MesUtilities {     class ExcelInterop     {           #region member fields           Excel.Application objApp;         Excel._Workbook objBook; … Continue reading

Posted in Parenting | Tagged , | Leave a comment

Excel Interop: Query into DataGridView, Save to spreadsheet, Open via Excel.

This requires ExcelInterop.cs           private void btnListAllUsers_Click(object sender, EventArgs e)         {             SaveListOfAllUsers();         }           private void SaveListOfAllUsers()         {             DataTable dtUserList = new DataTable();             // use an invisible DataGridView on the UI form. … Continue reading

Posted in Parenting | Tagged , | Leave a comment