Search Results for "excel vba programming"

SchoolMag is a free and opensource msexcel vba standard software for management of school. ANY PASSWORD CAN OPEN IT. Create a folder SchoolMaG1.4 in c drive of your pc and there extract the file SchoolMag1.4.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.

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).

...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.

OOF is a set of components which enable designers to create a back office, a front office, dynamic sites, forms, rich applications, database driven applications... This done with Flash or SILEX, by designers without programming skills.

DSQL ("Dynamic" SQL) is a scripting language for SQL, aka Perl for JDBC. It allows rapid development of code to perform database programming, data warehousing and import/export from databases, XML, Excel, etc.