Skip to content

igorkravitz/vba-praxis

Repository files navigation

vba-praxis

In file excel created macros in VBA training

quick-tables.xlsm is a macro with a user form in which you can create a table on a sheet from a list of columns on the form. You can open the form using the Quick_Tables_Click macro. When using the checkbox 'Open in a new window', the table will be created in a new file

sqlite-to-excel.xlsm is a macro loads all tables of the *.sqlite; *.sqlite3; *.db file into Excel. The first table displays information about the database, the rest of the tables contain data. See the list of macros, command to open file.

sqliteodbc.exe or sqliteodbc_w64.exe is needed if the SQLite ODBC driver is not installed on the window computer

Releases

No releases published

Packages

No packages published