GitHub topics: vba-excel

PerditionC/vbaPDF

VBA code for simple modification of PDF files (read in, combine, write out)

Language: VBA - Size: 5.03 MB - Last synced at: about 13 hours ago - Pushed at: about 13 hours ago - Stars: 5 - Forks: 0

spsanderson/steveondata

Repository for mainly R tips and tricks for my blog. I also include some VBA, SQL, C and Linux Usage.

Language: JavaScript - Size: 336 MB - Last synced at: 3 days ago - Pushed at: 3 days ago - Stars: 5 - Forks: 2

JWock82/xlFrame

A free VBA library to make structural analysis easy in Microsoft Excel

Language: VBA - Size: 333 KB - Last synced at: 3 days ago - Pushed at: almost 2 years ago - Stars: 78 - Forks: 25

tmgerard/vba-structural-engineering-math-library

A VBA library to aid structural engineers in common mathematical operations used in the analysis and design of structural systems.

Language: VBA - Size: 1.38 MB - Last synced at: 13 days ago - Pushed at: 13 days ago - Stars: 0 - Forks: 0

GowthamiGadugu/Certifications

Certifications that reflect my journey in data and tech—driven by curiosity, consistency, and a strong foundation in both technical and soft skills.

Size: 3.91 KB - Last synced at: 15 days ago - Pushed at: 15 days ago - Stars: 0 - Forks: 0

tstenborg/Webcam-Sampler

Automated sampling of webcam imaging via Excel VBA.

Language: VBA - Size: 69.3 KB - Last synced at: 15 days ago - Pushed at: 15 days ago - Stars: 1 - Forks: 1

jacinator/VBA-macros

These are Visual Basic macros which GFA Canada uses.

Language: VBA - Size: 4.88 KB - Last synced at: 18 days ago - Pushed at: 18 days ago - Stars: 6 - Forks: 2

manuelhm1993/dm-extractor-lista-de-precios

Extractor y generador de catálogos y pedidos, automatizando el envío de correos electrónicos a proveedores

Language: C# - Size: 1.64 MB - Last synced at: 20 days ago - Pushed at: 20 days ago - Stars: 0 - Forks: 0

Balasubramanian-pg/Excel-Portfolio-Project

Within this repository, you will discover a comprehensive compilation of Excel dashboards, visualizations, financial models, reports, and various data adventures that have been integral to my learning journey with Excel. These projects showcase the diverse range of skills and insights I gained while exploring and mastering Excel, providing a valuab

Size: 48.3 MB - Last synced at: 20 days ago - Pushed at: 20 days ago - Stars: 8 - Forks: 2

karuppu11/JP-Morgan-Chase-Virtual-Internship-main

Excel data analysis and storytelling project from the JPMorgan Chase & Co. virtual internship on Forage. Includes data cleaning, VBA macros, dashboards, and business insights.

Size: 2.05 MB - Last synced at: 23 days ago - Pushed at: 23 days ago - Stars: 0 - Forks: 0

FelixFreitasJr/CONTROLE-PFF-VBA

Sistema em Excel VBA para gestão de dispensação de máscaras N95 no ambiente hospitalar, com cadastro e controle por CPF para resposta à crise da COVID-19.

Language: VBA - Size: 2.16 MB - Last synced at: 28 days ago - Pushed at: 28 days ago - Stars: 1 - Forks: 0

cavo789/vba_excel_sql 📦

SQL Server to Microsoft Excel. VBA class for Excel to make easy to access records stored in SQL Server and output these data in an Excel sheet; keeping or not the link

Language: VBA - Size: 131 KB - Last synced at: 4 days ago - Pushed at: over 3 years ago - Stars: 49 - Forks: 11

cavo789/vba_excel_import_sheets 📦

VBA macro for trying to retrieve worksheets in a corrupt Excel file

Language: VBA - Size: 130 KB - Last synced at: 4 days ago - Pushed at: over 3 years ago - Stars: 2 - Forks: 0

JuliaMoc/Retail_Store_Inventory_Project

A complete Excel-based BI solution for retail sales and inventory analysis. Featuring dynamic dashboard, automated KPI report, and real-world workflow simulations — all built in Excel to showcase its power beyond spreadsheets.

Size: 20.6 MB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 0

MarcBasas/ChessExcel

ChessExcel is a simple chess game built entirely in Excel using VBA macros. The board is drawn with Unicode chess symbols, pieces are moved by selecting cells, and turns are managed via an ActiveX button.

Language: VBA - Size: 54.7 KB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 1 - Forks: 0

MuhsinaShehzad/call-center-performance

Interactive Excel dashboard analyzing 12 weeks of call center performance, including agent scores, call abandonment, and SLA metrics.

Size: 7.32 MB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 0

Rsge/Office-VBA-Utilities

A collection of various VBA scripts for different applications in MS Office, as well as some speed tests.

Language: VBA - Size: 220 KB - Last synced at: 29 days ago - Pushed at: about 1 month ago - Stars: 6 - Forks: 2

SSlinky/VBA-ExtendedDictionary

Dictionary object that extends the Scripting.Dictionary

Language: VBA - Size: 85.9 KB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 21 - Forks: 5

raulmaulidhino-dev/bugar-test-excel-vba

BugarTest is a simple, interactive and dynamic physical fitness test app created with Excel VBA App and Microsoft Excel.

Language: VBA - Size: 24 MB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 0

cavo789/vba_excel_RibbonDropdown 📦

How to very easily load an Excel range into the ribbon as a dropdown

Language: VBA - Size: 457 KB - Last synced at: 4 days ago - Pushed at: almost 3 years ago - Stars: 7 - Forks: 0

cavo789/vba_excel_export_code

Just like me, you write Excel macros and you want a simple way to export your code as text files to your hard disk so that you can manage versions and load the code into e. g. GitHub? My vba_excel_export_code script is made for you. From now on it also manages the export of your ribbon.

Language: VBScript - Size: 204 KB - Last synced at: 4 days ago - Pushed at: over 3 years ago - Stars: 27 - Forks: 8

areed1192/sigma_coding_youtube

This is a collection of all the code that can be found on my YouTube channel Sigma Coding.

Language: Jupyter Notebook - Size: 67.8 MB - Last synced at: about 1 month ago - Pushed at: about 3 years ago - Stars: 1,109 - Forks: 800

Excel-lent/ClooWrapperVBA

COM-wrapper of Cloo to execute OpenCL code from VBA/Excel.

Language: C# - Size: 286 KB - Last synced at: 13 days ago - Pushed at: over 1 year ago - Stars: 17 - Forks: 5

DecimalTurn/Excel-Pomodoro-Timer

Excel Pomodoro Timer

Language: VBA - Size: 951 KB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 16 - Forks: 3

haydengan/ExcelVBA_Workshop

Excel VBA Learning

Language: VBA - Size: 168 KB - Last synced at: about 2 months ago - Pushed at: about 2 months ago - Stars: 0 - Forks: 0

wendellribeironogueira/GestorDePolo_AutomacaoEstoquePagBank

Sistema VBA para Automação Logística e Relatórios Operacionais com Dados Workfinity (PagBank)

Language: VBA - Size: 2.89 MB - Last synced at: about 2 months ago - Pushed at: about 2 months ago - Stars: 0 - Forks: 0

HarvestMondello/excel-sales-dashboard

Coffee sales dashboard in Excel using Power Query and Macros (VBA)

Language: VBA - Size: 2.42 MB - Last synced at: about 2 months ago - Pushed at: about 2 months ago - Stars: 1 - Forks: 0

Olieveira/Gerador-de-Eventos

🗓️ Planilha automatizada em VBA para gerar e exportar cronogramas de eventos em diversos formatos (PDF, HTML, DOC, etc.).

Language: VBA - Size: 184 KB - Last synced at: about 2 months ago - Pushed at: about 2 months ago - Stars: 0 - Forks: 0

fatherShafiu/school_exeat_system

This is a school exeat application created in visual basic, and Microsoft excel. This has the structure of high school in mind.

Size: 161 KB - Last synced at: 26 days ago - Pushed at: over 2 years ago - Stars: 4 - Forks: 0

uezo/TinySeleniumVBA

A tiny Selenium wrapper written in pure VBA

Language: VBA - Size: 83 KB - Last synced at: 3 days ago - Pushed at: over 3 years ago - Stars: 63 - Forks: 17

ShortArrow/PowerConeSnail

This is Powershell Injection Framework for Excel VBA.

Language: PowerShell - Size: 125 KB - Last synced at: 3 days ago - Pushed at: over 3 years ago - Stars: 3 - Forks: 0

pchemguy/CSVParser

Parses delimited files (CSV) using pure VBA or Excel assisted VBA.

Language: VBA - Size: 503 KB - Last synced at: about 1 month ago - Pushed at: about 4 years ago - Stars: 5 - Forks: 1

bskinn/excel-csvexporter

Lightweight tool to export ranges within an Excel sheet to CSV

Language: VBA - Size: 70.3 KB - Last synced at: 15 days ago - Pushed at: over 3 years ago - Stars: 42 - Forks: 7

Zadigo/vba_codes

VBA snippets and code library

Language: Visual Basic .NET - Size: 55.7 KB - Last synced at: about 2 months ago - Pushed at: almost 2 years ago - Stars: 47 - Forks: 11

Mr-DragonStar/MS-Excel-VBACODE-Unlock-Sheet-Protect-Brute-Force

Script VBA de MS Excel, el Script rompe la seguridad de cualquier hoja "PROTEGIDA" con contraseña

Size: 3.91 KB - Last synced at: 2 months ago - Pushed at: 2 months ago - Stars: 0 - Forks: 0

Gagniuc/Binary-files-inside-EXCEL-VBA

This application converts any executable file to VBA source code that can be included as a '.bas' module in an EXCEL file. Once inserted into the EXCEL file, the VBA code can be used to completely restore the executable file to disk in the same directory as the EXCEL file.

Language: BASIC - Size: 3.55 MB - Last synced at: about 2 months ago - Pushed at: about 2 years ago - Stars: 25 - Forks: 6

lamtong/megawidget_intl_cashflow_analysis

This project develops a financial forecasting spreadsheet for MegaWidget International to simulate and analyse the company’s financial performance under different business scenarios, supporting strategic planning and risk management.

Size: 4.15 MB - Last synced at: 2 months ago - Pushed at: 2 months ago - Stars: 0 - Forks: 0

DylanJohnston/Excel-PowerQuery-VBA-Summary-Sheet

A summary sheet summarising the Excel, PowerQuery, and VBA learnt whilst taking online courses.

Language: TeX - Size: 1.16 MB - Last synced at: 10 days ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

stevecalderone/Chemical-Engineering-Thermodynamics

User Defined Functions for multi-component thermodynamic calculations of the Predictive Peng-Robinson 1978 Equation of State. Clean VBA functions - no UI changes and no pop up messages. Errors are reported in cell comments. Import Math.bas, ModArraySupport.bas and ChemE_Functions.bas into PData.xlsx and save as xlsm or simply download PData.xlsm.

Language: Visual Basic - Size: 5.04 MB - Last synced at: about 1 month ago - Pushed at: over 6 years ago - Stars: 49 - Forks: 11

sergey-frolov-pets/excel-helpers

Excel tools and VBA snippets for focused business tasks

Language: VBA - Size: 16.3 MB - Last synced at: 2 months ago - Pushed at: 2 months ago - Stars: 16 - Forks: 2

raphaelmuzzi/DataScience-Analytics

My Portfolio of Data Science and Analytics projects.

Language: Jupyter Notebook - Size: 1.84 MB - Last synced at: 2 months ago - Pushed at: 2 months ago - Stars: 1 - Forks: 0

aetonsi/vba-excel-utils

{vba} Collection of random VBA for Excel utils (forms, modules).

Language: VBA - Size: 16.6 KB - Last synced at: 3 days ago - Pushed at: 3 months ago - Stars: 1 - Forks: 0

abraham-ny/Jendie-Worksheets

Judiciary Milimani (network&systems division) worksheets repetitive/tedious task automated with vb script.

Language: VBScript - Size: 2.74 MB - Last synced at: 2 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

marwablaila/production_planning

Production Planning Automation using Linear Programming with VBA

Size: 2.93 KB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

miroslav-reiter/Kurz_Microsoft_Excel_VBA_IV

Kurz Microsoft Excel IV. Expert: Programovanie vo VBA

Language: Visual Basic - Size: 48.8 KB - Last synced at: 3 days ago - Pushed at: over 5 years ago - Stars: 6 - Forks: 2

opi1101/VBA-extensions

Common utility functions to extend VBA language and to speed up developement.

Language: VBA - Size: 78.1 KB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 1 - Forks: 0

opi1101/VBA-userforms

Common Excel UserForms to speed up developement.

Language: VBA - Size: 9.77 KB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

timothyausten/progressive-income-tax

Calculate progressive income tax based on a tax table using VBA

Language: VBA - Size: 0 Bytes - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

PGS62/JuliaExcel.jl

Call Julia from Microsoft Excel worksheets and from VBA

Language: VBA - Size: 21.7 MB - Last synced at: 4 days ago - Pushed at: 3 months ago - Stars: 59 - Forks: 6

MaxineXiong/SalesRegionalReportingTool

The Sales Regional Reporting Tool is an Excel template with VBA program that automates monthly reporting for Sales Controllers. It consolidates data, generates interactive regional reports, creates a regional overview report for top management, and exports data as a CSV file for the ERP system.

Language: VBA - Size: 9.99 MB - Last synced at: 3 months ago - Pushed at: about 2 years ago - Stars: 3 - Forks: 0

fafalone/cTaskDialog64

cTaskDialog (TaskDialogIndirect implementation) universally compatible with VB6/VBA7/twinBASIC x86/x64

Language: Visual Basic 6.0 - Size: 2.78 MB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 29 - Forks: 8

VictoriaRaven/NCAS-NASA-missions-personal-CC

NCAS-NASA-missions-personal , tasks, assignments, projects, and the codes

Size: 7.88 MB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

lburdier/Vos-Reves

Projet scolaire en équipe : missions informatiques pour l’entreprise fictive "Vos Rêves".

Language: Python - Size: 15.4 MB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

tonihamza/The-Yellow-Runner

The Yellow Runner is a fun game where you control a square to color the map while avoiding various enemies. Navigate through 100 levels, aiming to color the entire map or achieve over 80% coverage to advance. Use arrow keys to change direction and strategize against enemy movements. Enjoy endless fun and challenges!

Language: VBA - Size: 281 KB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

IbrahimEssakine/Dynamic_Vehicle_Routing_Problem

Le DVRP est un problème de routage des véhicules en temps réel, où l'objectif est de trouver les itinéraires optimaux pour minimiser les coûts et satisfaire les demandes des clients. Les destinations et les demandes évoluent en temps réel.

Size: 333 KB - Last synced at: 6 days ago - Pushed at: over 1 year ago - Stars: 3 - Forks: 0

IbrahimEssakine/Maintenance_Management_Dashboard

Efficiently plan and manage maintenance tasks with this maintenance management dashboard. This tool helps you streamline maintenance scheduling and track maintenance plans effectively. Built using Excel and VBA, it simplifies maintenance management, making it a powerful resource for maintenance professionals.

Size: 2.45 MB - Last synced at: 2 months ago - Pushed at: over 1 year ago - Stars: 3 - Forks: 1

DiegoVictor/2048

2048 game version built in VBA

Size: 46.9 KB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 1 - Forks: 0

prabhupavitra/Financial-Modeling

Financial Models using vba script and Python

Language: Jupyter Notebook - Size: 4.37 MB - Last synced at: 3 months ago - Pushed at: about 4 years ago - Stars: 25 - Forks: 7

GregDataMiner/Outil-de-gestion-de-portefeuilles-VBA

projet de gestion de portefeuille en VBA

Size: 168 KB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

robinyeon/Excel-Integration-test-tool

📊 Excel VBA 기반 통합 테스트 자동화

Size: 1.99 MB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

RolandJunior/Coordinate_Converter

Excel VBA file to convert a coordinate list from Decimal Degrees to DMS and vice versa.

Size: 24.4 KB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 1 - Forks: 0

metatronslove/isimler-ve-ebced-degerleri Fork of kahramankostas/isimler-ve-ebced-de-erleri

bazı isimlerin osmanlıca yazılışları ve Sahur Özel'in Ebced Hesaplayan makrolarıyla hesaplanmış ebced değerleri

Language: Python - Size: 658 KB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 1 - Forks: 0

hussamaldouj/codebarcode

code barcode with micro and excel

Language: VBA - Size: 2.93 KB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

carvetighter/VBA-Code-Library

A series of Visual Basic Applications (VBA) methods I wrote, mostly for Excel, to increase the speed and accuracy in working with data, charts and databases.

Language: Visual Basic - Size: 1.75 MB - Last synced at: 3 months ago - Pushed at: over 3 years ago - Stars: 176 - Forks: 40

MaxineXiong/AutomateTableOfContentsInExcel

The VBA program automatically generates table of contents for Excel workbooks. By eliminating manual effort, it saves time and ensures a comprehensive table with clickable sheet links. The repository provides the necessary code, a sample workbook, and clear instructions for easy integration and usage, enhancing productivity for Excel users.

Language: VBA - Size: 125 KB - Last synced at: 3 months ago - Pushed at: about 2 years ago - Stars: 3 - Forks: 0

Sharkb8t/VBA-challenge

Demonstrate proficiency in data analysis of CSV files using VBA Script.

Language: VBA - Size: 2.13 MB - Last synced at: 3 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

nhuhth/VBA

Collection of VBA projects automating tasks in Excel, such as data processing, report generation, and custom analytics. Includes reusable modules for efficiency improvements, error handling, and user interface customization.

Language: Rich Text Format - Size: 43 KB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

kumatech112/Futo-Kuma

Excel VBA

Size: 12.7 KB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

Rabadash8820/VbaModuleManager

A VBA macro that facilitates version control by automatically importing/exporting other VBA macros in Office documents.

Language: VBA - Size: 201 KB - Last synced at: 3 months ago - Pushed at: about 2 years ago - Stars: 32 - Forks: 8

Hrsj123/VBA-PowerQuery-PDFTables

Access table data from PDF files directly into VBA using PowerQuery (for MS 365). This repository provides a streamlined approach for Excel Macros to extract structured table data from PDFs into VBA, enabling efficient automation of data processing tasks.

Language: VBA - Size: 3.91 KB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

K4KarolE/VBA

VBA, macros, Excel - learn & archive

Size: 1.32 MB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

isatoya/Own_creations

Projects and developments

Size: 297 KB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 1

ewdlop/VB-Note

Visual Basic;https://en.wikipedia.org/wiki/Bill_Gates

Language: QuickBASIC - Size: 73.2 KB - Last synced at: 3 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

VictorLawrenceSim/VictorLawrenceSim-LibraryPartsGenerator

Writes a xml file to produce parts in Flotherm. The parts include fans and blowers

Size: 0 Bytes - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

happybono/GEOSage

A VBA application for geocoding and reverse geocoding in Microsoft Excel. Supports both Google's free and enterprise for business geocoder (Google Maps APIs for Business, Google Maps for Work or Google Maps).

Language: VBA - Size: 586 KB - Last synced at: 3 months ago - Pushed at: 4 months ago - Stars: 11 - Forks: 4

JosefSedlacek/Gumokov-VBA-codes

Tento Repository slouží jako skladiště kódu ve VBA, který používám pro správné fungování aplikací v MS Excel a pro účely aktualizací (exportu) dat ze SAP

Language: VBA - Size: 85 KB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

IsraelVow/Expense-Management-System-VBA-Excel-Project-

Captures all expenses and displays analytic representation of the data entered in real time

Size: 21.2 MB - Last synced at: 5 months ago - Pushed at: 5 months ago - Stars: 8 - Forks: 2

MaxineXiong/InvoiceGenerator

The Invoice Generator is a highly customizable, Excel-based tool with VBA programs that automates the process of invoicing, streamlining invoice management and generation, and enhancing efficiency. It offers easy customer data management, one-click invoice creation, email integration, and informative dashboard charts for revenue monitoring.

Language: VBA - Size: 1.03 MB - Last synced at: 3 months ago - Pushed at: about 2 years ago - Stars: 10 - Forks: 2