Skip to content
A set of libraries in order to increase your productivity using Excel and VBA
Visual Basic
Branch: master
Clone or download
Latest commit 3025f38 Apr 9, 2015
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
docs Added documentation on getFileUpdateTime Dec 7, 2014
excel-classes wrong commit Nov 2, 2014
excel-libraries Update LIB_Folder.bas Apr 9, 2015
others wrong commit Nov 2, 2014
Readme.md Revision of LIB_Range. Removal of inline doc and creation of dic file Nov 2, 2014

Readme.md

Excel VBA Productivity Libraries

##Introduction

Excel VBA PL is a repo containing VBA files for Excel, aiming at enhancing your productivity while developing your Excel files by filling some gaps of Excel.

It proposes:

  • A class to interact with Word
  • Functions to work with files
  • Functions to work with folders
  • Functions to work with regular expressions
  • And other functions that aims at enhancing current functions of Excel or creating new one

General Philosophy

You will want to use Excel VBA PL if you want to respect the philosophy of Excel. Meaning that you want to use Excel functions within a document that will be easily understandable by anyone opening your workbook.

You will however be disapointed if you are one of those Excel developers which develop Excel applications.

When working with Excel, I realised that it is more powerful, productive and efficient to touch as less as possible the VBA codes. This is way I preconise to create Excel functions or create classes that allow a neat OO way of programming.

How to install a file?

In order to work with a library in your Excel workbook, simply drag-and-drop your selected .bas file within the Visual Basic Editor of Excel.

Documentation

The documentation is in construction, not all the files are documented here

  • LIB_File: Library to handle file writing and reading
  • LIB_Range: Library to provide additional manipulations on Ranges
You can’t perform that action at this time.