Personal library of reusable VBA modules for Excel, Access and PowerPoint automation, ETL, files and strings.
In the VBA editor (Alt+F11): File → Import File… and choose the .bas modules you need. Some modules depend on others (for example bas_lib_global_0001.bas and bas_lib_error_0001.bas); import those too.
| Area | Files |
|---|---|
| Excel | bas_lib_excel_0001 … 0005, bas_lib_excel_shape_0001 |
| PowerPoint | bas_lib_ppt_0001, bas_lib_ppt_shape_0001 |
| Access and databases | bas_lib_access_0001, bas_lib_db_0001, bas_lib_etl_0001 |
| Files and folders | bas_lib_file_0001, bas_lib_folder_0001, bas_lib_path_0001 |
| Data structures | bas_lib_array_0001, bas_lib_asoc_array_0001 |
| Text and search | bas_lib_str_0001, bas_lib_search_0001 |
| Math, random, time | bas_lib_math_0001, bas_lib_rand_0001, bas_lib_time_0001 |
| UI | bas_lib_color_0001, bas_lib_control_0001 |
| Infrastructure | bas_lib_global_0001, bas_lib_error_0001, bas_lib_log_0001, bas_lib_references_0001, bas_lib_vba_0001, bas_lib_windows_0001 |
Note: .bas files are kept in Windows ANSI encoding, which the VBA editor expects.