Posts

Showing posts from October, 2013

Microsoft Excel - Save As CSV (Macro)

This is a macro which will help you to save a worksheet to CSV (Comma-Separated Values) using a shortcut key. The trick is to execute a customized macro named "SaveAsCSV". You may further modify this macro to work for other format. Discussion below will be focused on using CSV format. How does it work? Save active excel file. Get file name for active excel file. Get current sheet name. Check if sheet name contains desired extension (.csv) Append file extension if required. Save current sheet as desired format (CSV). Close current CSV File. Reload active excel file.

Dynamic Load Assembly

Image
Introduction    Dynamic library loading is nothing new in native C++. In Microsoft Window’s implementation, this capability is realized with the use of Dynamic Link Library (DLL) . This feature greatly expands the flexibility of an application where new features can be added / modified in the form of plug-in without the need to recompile the entire application. Similar capability is provided in .NET framework to dynamically load assemblies which make plug-in development for .NET based application possible. Moreover, dynamic assembly loading that .NET framework provides is much more powerful than native C++ DLL. Wikipedia : plug-in is a software component that adds a specific feature to an existing software application.  Download Demo Download Sample Project