The excel-vba repository is a collection of handy Excel 2010 VBA modules for chart object manipulation, textfile handling (import, search, export) and more. The usage of the VBA routines and functions contained is shown in the demo sheets of the Excel 2010 excel-vba.xlsm file. There are no dependencies to other VBA projects, allowing you to use only the features you need.
- basAPI: Windows API routines to deal with user forms (e.g. borderless form)
- basCharts: Routines for the creation and manipulation of chart objects embedded on worksheets
- basIO: Routines to import textfiles into sheets and to export a sheet as CSV file
- basXSearch: Routines to search sheets for multiple search patterns
- API, frmAPI: Demo of the basAPI routines
- Charts: Demo of the basChart routines
- IO: Demo of the basIO routines
- xSearch: Demo of the basXSearch routines
You can download the latest development branch of the excel-vba package using GitHubs ZIP button.
The excel-vba package is licensed under the GNU General Public License 3.0.
The excel-vba package was tested with Excel 2010 on a Windows 7 operating system. It may work for other platforms as well, but was not tested for.