Search Results for "vba macro excel"

Spreadsheet Compare (Excel compare) is a Microsoft Excel Add-In, written in VBA, that performs a cell-by-cell comparison of Worksheets within the same or different Workbooks. Requires Excel 2000 or later. Check out the Home Page for more info!

SchoolMag is a free and opensource msexcel vba standard software for management of school. ANY PASSWORD CAN OPEN IT. Create a folder SchoolManagement in c drive of your pc and there extract the file SchoolMag15.zip. First go to excel option Trust Centre, trust centre setting, macro setting and opt for enable macro, then go to ActiveX setting and opt for enable control without restriction and then click on ok.

This Data Dictionary Generator tool is easier and faster to use than scripts to easily document an existing database schema. You can dump the tables, views, column descriptions, data types/lengths/sizes/precision, key constraints, and othr information. Results can be instantly exported to CSV, Excel, or even PDF. You can generate just the comments script for tables and columns for you to edit and run, then put under source control. You can output the SQL script used to generate the data...

Mar 2025 - Project moved to Github: https://github.com/symbolthree/exzellenz EXZELLENZ is a pure-Java program to manipulate table data in Oracle database through Microsoft Excel file (in xls and xlsx formats). Using Apache POI and JDBC API, this program can be used to download, insert, update, and delete data in database tables. It does not use any Office VBA, so you don't need to change the Excel security settings, and no need to worry the 32/64bit compatibility. Written in Pure-Java means that you can also run this program in Windows, *nix or Mac environment, as long as you maintain the file in Excel format (through Open/Libre Office).

This database modeling utility is an excel workbook to help you to design database. It supports DB2, MariaDB, MySQL, Oracle, SQLite and SQL Server. In the excel workbook, you can define database, generate SQL scripts and import database definition from database. The office site is https://github.com/snyang/Database-Modeling-Excel

Excel allows the simple creation of reports and tables, this project is to create an API for the manipulation of Census and other data in such a way that customizable reports and tables can easily be generated for any (and aggregated) geographies from Census and other available data.

...However, the columns (fields) can easily modified, added or deleted so that the database can be customised according to your needs. Database Pro is available in file formats for both Excel and OpenOffice. The Excel version is a VBA project and the OpenOffice version uses OOo Basic. Please note that the database does not currently work with LibreOffice due to a couple of bugs in the LibreOffice program.

SQLiteCel is a simple Excel Interface to SQLite designed to help you edit, view and analyze data from SQLite databases.