Code Monkey home page Code Monkey logo

excel-vba-productivity-libraries's Introduction

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

excel-vba-productivity-libraries's People

Contributors

emilefyon avatar miguelfernandezgutierrez avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.