ximaera / libsex Welcome to your wiki! This is the default page we've installed for your convenience. Go ahead and edit it. Visual Basic/VB6 Command Reference This page aims to be a comprehensive command reference to the MS Visual Basic 6 programming language. String Manipulation Asc
Excellaneous Introduction The latest (3rd) edition of Advanced Excel A textbook for a course in scientific data analysis A demo of what you can now do in Excel with Matrix and XN Incorporating Matrix and/or XN functions and macros in VBA Other features on this websiteProblems using the MacroBundle in Excel2007/2010 An improved macro for the first derivative Quasi-contour diagrams Additional aspects of surface graphs The color index Excel & VBA pitfalls Increasing computational precision The contents of the MacroBundle The contents of the other downloads The GNU General Public License The latest updates The downloads Introduction This website is meant for scientists and engineers who want to use the ubiquity, convenience and power of Excel, including its flexibility to go beyond the functionality already provided by Microsoft.
Component Object Model Overview Unlike C++, COM provides a stable ABI that does not change between compiler releases. This makes COM interfaces attractive for object-oriented C++ libraries that are to be used by clients compiled using different compiler versions. History One of the first methods of interprocess communication in Windows was Dynamic Data Exchange (DDE), first introduced in 1987, that allowed sending and receiving messages in so-called "conversations" between applications. Object Linking and Embedding (OLE), Microsoft's first object-based framework, was built on top of DDE and designed specifically for compound documents. It was introduced with Word for Windows and Excel in 1991, and was later included with Windows, starting with version 3.1 in 1992.
Visual Basic Code is a 'all-in-one' Add-In for Visual Basic 6.0 which adds several features missing in the VB 6.0 IDE. It provides a main menu, a toolbar, handy context menus or customizable shortcuts to access those features. Through a dialog window, you can customize several Add-In features to meet your development standards (data type prefixes, template for procedure headers, template for error handler, etc.) or your personal preferences (user name, shortcuts, etc.)
Welcome to the Visual Basic for Applications Language Reference for Office 2010 Welcome to the Visual Basic for Applications (VBA) language reference for Office 2013. This reference contains conceptual overviews, programming tasks, samples, and references to guide you in developing solutions based on VBA. Initial publication: July 2012 | Updated: November 2012 Excel Macros Dim Wb As Workbook SaveAll For Each Wb In Workbooks If Wb.Name <> ThisWorkbook.Name Then Wb.Close savechanges:=True End If Next Wb ThisWorkbook.Close savechanges:=True Closing All Inactive Workbooks This macro will close all of the workbooks, except the active workbook, which will remain open active. Public Sub CloseAllInactive()
A Fast CSV Reader Introduction One would imagine that parsing CSV files is a straightforward and boring task. I was thinking that too, until I had to parse several CSV files of a couple GB each. After trying to use the OLEDB JET driver and various Regular Expressions, I still ran into serious performance problems. At this point, I decided I would try the custom class option. I scoured the net for existing code, but finding a correct, fast, and efficient CSV parser and reader is not so simple, whatever platform/language you fancy.
The Spreadsheet Page - PUP/Mac Home New Tools for Excel 2011 for Mac Power Utility Pak for Mac is a useful collection of add-ins that brings significant new functionality to Excel 2011 for Mac. When PUP is installed, you can do things with Excel that you never thought were possible. Regardless of your experience level, you'll find features in PUP that can make your job easier. Category:Free computer libraries This category is for toolkits and libraries for application programmers which are distributed as free software - under a free software licence, with the source code available. Subcategories This category has the following 6 subcategories, out of 6 total.