Search Results for "excel vba code writer"
Sort By:
Showing 29 open source projects for "excel vba code writer"
View related business solutions-
Boost application security and continuity with SKUDONET ADC, our Open Source Load Balancer, that maximizes IT infrastructure flexibility. Additionally, save up to $470 K per incident with AI and SKUDONET solutions, further enhancing your organization’s risk management and cost-efficiency strategies.
-
Track all your service data in one easy-to-use system, enabling your team to move faster and generate more revenue for your bottom line.
-
1
XLSX.jl
Excel file reader and writer for the Julia language
XLSX.jl is a Julia package to read and write Excel spreadsheet files. Internally, an Excel XLSX file is just a Zip file with a set of XML files inside. The formats for these XML files are described in the Standard ECMA-376. This package follows the EMCA-376 to parse and generate XLSX files. -
2
Excel to Graphviz
A Microsoft Excel spreadsheet which creates Graphviz graphs
Takes Excel data relationships and creates Graphviz graph visualizations. -
3
ClooWrapperVBA
COM-wrapper of Cloo to execute OpenCL code from Excel.
The wrapper allows to execute OpenCL code on CPU and GPU devices from VBA. Sources are available under https://github.com/Excel-lent/ClooWrapperVBA -
4
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. -
AlertBot monitors your website's full functionality around the clock so you can focus your time on more important things.
-
5
Build & Lexigraphical Permutations
Documentation of two types of permutation algorithms
... 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. -
6
DAPS4
A Fortran code for design and analysis of ring-stiffened shells
... Elastic Instability analysis (EFI). Solutions compare favorably with DTMB experimental results. DAPS4e’s IO is managed through a Visual Basic user form. Pre/post processing is done using linked macro-enabled Excel spreadsheets. The file DAPS4e.zip includes: • DAPS4e.3 executable and Fortran 77/95 source code. • Visual Basic user form and its 2017 Visual Studio project code. • Excel spreadsheet pre/post processors. • Comprehensive technical documentation. -
7
Tagebuch.xls
Zeiterfassung Excel - Time Tracking - Arbeitszeiterfassung
Tagebuch.xls ist ein Zeiterfassungs-Tool basierend auf Excel. Die in VBA programmierte App erlaubt es Projekte und Arbeitszeiten zu erfassen und in Excel darzustellen. Zusätzliche Berichtdateien basierend auf den Daten im Tagebuch können erstellt werden und sind durch Dritte leicht weiter verarbeitbar. -
8
Planar Elastica
A collection of technical notes on planar elasticas and sample code
The collection Planar Elastica (Planar Elastica.zip) includes: 1. A technical note deriving the governing equations for a planar elastic subjected to general end loading (i.e., combined bending moment, angled direct load and torsional moment). This note is heart of this project. 2. Macro enabled Excel spreadsheet examples that illustrate use of the above result. These examples range in sophistication from large displacement leaf springs to one requiring simultaneous solution of two elastica... -
9
Free VCF file to CSV or Excel converter
Excel VBA Script to convert VCF file with multiple entries to CSV file
This is an Excel based VBA script used to import bulk .VCF files that contain more than 1 Vcard and then convert them to a comma separated .CSV file or Excel xls file that can then be imported into Outlook, Google, or any other application that supports import of contacts using CSV files. This has been written to support VCF 2.0, 2.1, 3.0 and 4.0 formatted files including those with printable encoding (MIME) and has been tested with bulk VCF files from Backupify, Google Contacts (Gmail... -
WorkforceHub is the instantly useful, delightfully simple to use, small business solution for tracking time, scheduling and hiring. It scales as your business grows while delivering the mission-critical features an organization needs. It is tailored to, built for, and priced for small business employers.
-
10
My Test Case Manager
A lean, flexible XL test case manager for small to midsize projects
... project team. Show them how test cycles work, how test cases are built up over time, how regression testing works with each new build received, how risk is managed from build test to build test, etc. See GitHub link for documentation, larger template, and "source code" (it's a codeless XLSX file). Requires Excel for Office 365. GitHub: https://github.com/DataResearchLabs/my_test_case_manager YouTube Tutorials: https://www.youtube.com/playlist?list=PLVHoUDdbskUSZQsl0iexHwRGb8Z7_EjlS -
11
Excel Google Earth KML Creator
Convert site coordinates, sectors and MW links in Excel to KML format
This handy Excel VBA macro was designed for the telecom market, where you are able to convert points to KML, as well as sectors (as used in mobile network base stations) and links (as used for microwave links). Technical info presented in the resulting KML output file is not to be used for engineering / planning purposes. This was not the intention of this VBA tool. The only intention was to create a conversion tool with additional information presented in the KML file for display only purpose... -
12
BERT
Connector for Excel and the programming languages R and Julia
... in real time, right from your R code. And (if you want), you can call R functions from VBA as well. -
13
Excel Timer
Opens Excel files, waits for timer countdown, then closes the files.
OpenExcel is a command line utility program that provides the ability to open one or multiple Excel files, wait a specified number of seconds, and then close the workbooks. An alternative option is to use TASKKILL, however that approach closes all instances of Excel. The advantage of OpenExcel is that it only closes the specific workbooks. OpenExcel is useful for Excel files that implement VBA scripts with the events Workbook_Open and Workbook_BeforeClose. For example, the Workbook_Open event... -
14
TCL TK VBA geolog code writer
VBA add-in for writing TCL/TK code blocks
TCL/TK is a rapid development scripting language but it's not object orientated. So instead of having classes and objects I wrote this program to generate blocks of commonly used geolog TCL/TK code. It automatically generates blocks of Tcl Puts code, Mui Dialog Boxes and Mui Selection Boxes from UNIX flat ascii files. To run the program load the XLA file into Excel then press CTRL + T to fire up the form. If your ascii files are in DOS rather than UNIX format you will not be able... -
15
Column
Quick column reference for Excel® VBA programming
This is a simple program for Excel® VBA programmers. It provides a quick column name/number conversion. For instance, if you want to use a Cells(row, column) reference, you need to know the column number. Type the column name (for instance "CN") in the Input box. Output will display the column number (92). Conversely, if you are working on your code and want to know what column it refers to in the spreadsheet, type the column number in the Input box (for instance 456). Output will display... -
16
PCNetMonitor
Computer performance display and logging program
Local and remote computer performance display and logging program with Excel plotting interface and many other powerful features. -
17
Excel VBA Particle Swarm Optimization
A small tool for optimization of complex problems.
This is a Particle Swarm Optimization tool written in VBA for Excel. It is easy to modify in order to enable the users to code their own objective function, constraints and way to handle constraints. Published under licence CC-BY-SA 4.0 -
18
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 TK front...
-
19
Excel Report Generator
Excel based report designer and report writer
Report designer and generation tool developed exclusively within Excel using VBA. The tool allows the user to: - design a business report specifying report, page, group, subgroup and details (headers and footers where applicable) - format report in Excel (using Excel standard functionality) - preview report - print reports in various formats e.g. pdf, word, excel, printer, internet (google docs), etc. -
20
Badmintontourney
A badminton tournament planner spreadsheet
A Excel spreadsheet to organize and manage badminton tournament. Include match schedule conflict gestion and court availability. Since it is a excel workbook, everyone with spreadsheet experience can use it easily I'm looking for people to test and comment on the application. And hopefully collaborator with programming skills to help me with new features I cannot implement. As you will see by looking at the code, I'm no programmer and everything was done mostly by copy/past chunk of code... -
21
Lego Charts for Excel
Plot Excel data as photo-realistic 3D LEGO® models
Using a sequence of Open Source CAD/CAM and graphics tools, integrated through Excel macro code, "Lego Charts" extends the idea of the Excel 3-D bar chart. It allows the placement, shapes and colours of the bars to represent further dimensions to the data. The chart is presented as a photo-realistic model apparently constructed out of LEGO® [1] bricks. The downloaded package consists of an Excel template to create the charts, an extensive installation and user guide, and two fully-worked... -
22
SAP PI : MappingMaster
MappingMaster - Way to SAP PI Mapping documentation
MappingMaster is a simple Excel based application that helps generating SAP PI Mapping documentation. Although there are tools available already for this, there is something special about MappingMaster. For details, please check http://scn.sap.com/community/pi-and-soa-middleware/blog/2011/12/19/lets-excel-mappingmaster-is-here . -
23
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 -
24
This is a C# class handling all known CSV file types including all related issues like line breaks, etc. pp.. The source code is self- explaining and well documented. The project includes an Excel 2010 Add-In to add better CSV handling to Excel.
-
25
Project has PHP code to copy the distance in km from routeplanners (anwb and google maps). The VBA code in the excel worksheet uses the php-application to use the copy the distance in km to Excel.