Search Results for "excel vba programming"
Sort By:
Showing 28 open source projects for "excel vba programming"
View related business solutions-
The Most Powerful Software Platform for EHSQ and ESG ManagementChoose from a complete set of software solutions across EHSQ that address all aspects of top performing Environmental, Health and Safety, and Quality management programs.
-
Skillfully - The future of skills based hiringSkillfully transforms hiring through AI-powered skill simulations that show you how candidates actually perform before you hire them. Our platform helps companies cut through AI-generated resumes and rehearsed interviews by validating real capabilities in action. Through dynamic job specific simulations and skill-based assessments, companies like Bloomberg and McKinsey have cut screening time by 50% while dramatically improving hire quality.
-
1
Nushell
A new type of shell
NuShell (often shortened to “Nu”) is a modern, cross-platform shell written in Rust that treats all data as structured tables rather than plain text. It supports pipelines on rich typed data, has built-in commands for JSON/CSV/SQL/excel, and offers scripting, autocompletion, scoped variables, and strong error handling—bridging the gap between shell scripting and programming. -
2
Combinations Algorithm
Documentation and coding for the generation of combinations
This project comprises documentation and VBA programming code in respect of a combinations algorithm that I have written. The algorithm is in the Excel file named Combinations.xlsm and the documentation that explains how to use interface and execution of the algorithm is in the pdf file called Combinations.pdf You will need to enable macros in Excel in order to run the algorithm. -
3
Build & Lexigraphical Permutations
Documentation of two types of permutation algorithms
...The challenge is to create an efficient algorithm that can have the capacity to permutate sources texts that are hundreds and thousands of characters long without running out of memory. This project has 4 download files (1 pdf that documents the algorithms, and 3 Excel files, each for a different algorithm) The downloadable Excel files are the programming files because I code in VBA. You will need to enable macros to run the algorithms. You can view the VBA code of each algorithm from the developer module house inside Microsoft Excel. The lexigraphical algorithm is faster because it supports multi-threading. -
4
My Test Case Manager
A lean, flexible XL test case manager for small to midsize projects
MTCM is a lean test tool designed to organize test cases and manage/communicate test results. MTCM is a simple, minimalist design for software test engineers conducting functional or exploratory testing. Business analysts can also use MTCM for conducting user acceptance testing (UAT). You can write the test cases as you execute them, or plan and write them ahead of time. Run results are tallied and graphed on subsequent worksheets. You use the report and graphs to communicate status to your... -
MicroStation by Bentley Systems is the trusted computer-aided design (CAD) software built specifically for infrastructure design.MicroStation is the only computer-aided design software for infrastructure design, helping architects and engineers like you bring their vision to life, present their designs to their clients, and deliver their projects to the community.
-
5
XLW is a C++ wrapper for the Excel C API described in the Microsoft Excel 97 Developer's Kit. It makes xll programming automatic. Its powerful interface will empower your C, C# or C++ numerics by embedding them in Excel just like the built-in functions.
-
6
WinPayXL2020
This is a sample payroll program, for learning payroll and MS-Access
This is a sample/educational demo payroll program, for learning payroll and MS-Access programming. It is similar to the web app WebPayAS2019, written in PHP/MySQL. WinPayXL is for a small business, with 1-15 employees. It should give you practice in learning payroll, installing on the Windows Desktop, and learning MS-Access. The WinPayXL App calculates payroll, and produces reports for tax and accounting purposes. New features for 2020 include this years Tax Percentages, and ability to... -
7
Excel to Graphviz
Create graphviz diagrams with excel
Free, easy to use, excel tool to create data and process flow diagrams with table data In separate excel sheets you define items(nodes), lines(edges) and grouping(clusters) Separate definition of node, edge and cluster styles Graph settings sheet Output control sheet Examples and readme are included in the zip file Get it working: -Install graphviz (http://graphviz.org/Download.php) -Download Excel to Graphviz -Open one of the ExcelToGraphviz workbooks -Go to sheet settings... -
8
database modeling excel
A spreadsheet for designing databases
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 -
9
TCL TK VBA geolog code writer
VBA add-in for writing TCL/TK code blocks
...DOS uses carriage return and line feed ("\r\n") as a line ending, which Unix uses just line feed ("\n"). In VBA these are Chr(13) <- return and Chr(10) < line feed -
Simplify Purchasing For Your BusinessSimplify every aspect of buying for your business in Order.co. From sourcing products to scaling purchasing across locations to automating your AP and approvals workstreams, Order.co is the platform of choice for growing businesses.
-
10
This XLS spreadsheet automatically generates TCL/TK command line interfaces for both UNIX and Windows environments. Originally written for xval the program https://sourceforge.net/p/xval/wiki/Home/ it generates button and clickbox select front ends for various different command line tools. Blocks of code are then generated from a simple spreadsheet format. The attached powerpoint explains which parts of the Excel spreadsheet generate which bits of TK front end. The generated...
-
11
ExcelPython
An interface for calling Python from Excel
ExcelPython is a lightweight, easily distributable library for interfacing Excel and Python. It enables easy access to Python scripts from Excel VBA, allowing you to substitute VBA with Python for complex automation tasks which would be facilitated by Python's extensive standard library. v2 is a major rewrite of ExcelPython! - see GitHub site for more details. LICENSE NOTICE MIT License, please see new GitHub site for more details. -
12
Picartesius
Excel/VBA Integration of Picat programming language
Picartesius is a VBA library created by Lorenz Schiffmann for integrating Picat in Excel Spreadsheets. https://sourceforge.net/projects/picartesius Picat is a simple, and yet powerful, logic-based multi-paradigm programming language created by Neng-Fa Zhou and Jonathan Fruhman aimed for general-purpose applications. http://picat-lang.org -
13
VBA GetText
VBA GetText provides basic I18N and L10N for Excel VBA projects.
VBA GetText consists of several Visual Basic for Application modules and classes to enable internationalization (I18N) and localization (L10N) for VBA projects. It uses the GNU gettext-compatible PO file format for string translations; therefore, translators will be able to use standard PO file translation tools (e.g., Poedit) to translate strings. The VBA components are being written and maintained for the xltoolbox project. -
14
Excel VBA Developer Tools
Excel addin to facilitate VBA development.
Developer tools for Visual Basic for Applications in Excel. Import, export and delete modules using a user-friendly UI. Also provides tools for translations using the VBAGettext components (http://vbagettext.sf.net). These tools integrate as a "Dev Tools" menu into the Visual Basic Editor (VBE). -
15
aself
a selenium framework
A selenium framework to do automation testing without any prior selenium knowledge and without any programming knowledge. -
16
LDIF to XLS (Excel) module
Module for Microsoft Excel 2003 or below to conver LDIF file to .XLS
ENGLISH: (Español más abajo) Module (.bas) based on VBA (Visual Basic for Applications) to convert a LDIF file, dowloaded from any LDAP server such Active Directory from Microsoft, to a Microsoft Excel sheet called "Destino". Fully tested on Microsoft Excel 2003 or below, but haven't been tested on 2007 and above. How to use: Search the forum. Check the Forum for help. Please review the module and ask for help in the forum if you want. -
17
f2what
Lapack/quadprog QP for VBA/.Net/Java
F2what is an open source project to translate algorithmic fortran to a variety of languages (java, dotnet and VBA so far). It offers a Fortran77 parser with code transformations, variable disambiguation, and modular output to other programming languages. It also offers already translated versions of Lapack and quadprog to Java, .Net and VBA, to give access to SVD, LU, QR, Cholesky, eigenvalue decomposition, linear system solving and QP optimization in those three languages. -
18
msofficesvn
Microsoft Office add-ins that assist documen version control
This is an archive of a project that is currently maintained on the GitHub platform. Download the latest release from here: https://github.com/msofficesvn/msofficesvn/releases Get access to the source code right there: https://github.com/msofficesvn/msofficesvn -
19
ActiveLock is an open-source copy protection, software licensing framework for all development enviroments supporting COM+ architecture. Core DLL available in VB2008 and VB6. Samples in C++, C#, Excel/Access VBA and keygens in PHP, ASP.NET available.
-
20
DATA Gen™
DATA Gen™ - Test Data Generator to generate realistic test data.
DATA Gen™ Test Data Generator offers facilities to automate the task of creating test data for new or existing data bases. It helps lower the programming effort required, while reducing manual test data generation errors and the ripple effect that they cause on production systems, users and maintenance. -
21
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.
-
22
Simple V converts FHX files created by the Delta V programming laguage into easily readable charts. Allows reviewing of code without havaing the Delta V ide installed.
-
23
XML2CSV Spreadsheet Converter
Converts XML to CSV using a spreadsheet app
An MS Excel VBA macro converts XML to CSV. It demonstrates this capability by converting an XML-based Continuity of Care Document (CCD) into a slim Comma Separated Value (CSV) file. -
24
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.
-
25
Invisible Basic is an Excel Add-in that compiles the VBA code within an Excel Workbook into obfuscated (very hard to understand) but functionally equivalent code. Simply "Save Invisibly" to share your Excel solutions...without sharing their source code.
