just-VBA
crypto_vba
just-VBA | crypto_vba | |
---|---|---|
46 | 4 | |
29 | 154 | |
- | - | |
8.8 | 0.0 | |
12 days ago | over 1 year ago | |
VBA | VBA | |
GNU General Public License v3.0 only | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
just-VBA
-
Settings Management that moves with your workbook and supports custom settings by OS and / or User
I'd be happy to answer questions if you have any. Did you download the demo file for the FunWithListObjects?
-
How to enable very fast wildcard searches on large tables
The demo file can be downloaded from my github here: https://github.com/lopperman/just-VBA/blob/main/Misc/arraySearch.xlsx
-
Quickest way to duplicate rows based on value in a column
I'm not the best at documenting -- but I've been working on that. If you want to keep an eye on things I build, just follow my just-VBA repo on github. You can also follow me on reddit if you want to see what I post about -- i tend to post a lot :-)
-
Are you logging? If not, consider dropping this module into your project and you'll be good to start logging immediately
To that end, I created the pbLogging.bas module. It's reasonably commented, but feedback is welcome on that. Once imported into your project, you can immediately start logging by calling the pbLog function:
-
Simplify deleting User-Selected ListObject Rows. Handles sheet protection, non-contiguous selection, databodyrange boundary control
Download Functional Demo Workbook, or the code
-
[Excel] autogenerate sheets for the entire month at the beginning of each month.
author (c) Paul Brower https://github.com/lopperman/just-VBA
-
Enable users to dbl-click a cell in a ListObject or regular range, and replace or clear all matching values in column, or fill blanks
Descriptions and example of recommended usage are available in the RangeUpdateUtil.xlsm file, which can be found in this github location
-
Suffering with Excel for Mac? Get Parallels.
What are some of the things in excel that you 'suffered' on a Mac? I'm coming at this from a curiosity standpoint. I've built quite a bit of tools/libraries over the past few years for Excel/VBA. 100% of everything I've done is Mac and PC compatible (feel free to check my post history or my just-VBA github project). The only thing that's a bit tedious is working with custom User Forms, but it can still be done.
-
A Fast and Simple Settings Management Module. Automatically sets everything up and works for PC or MAC
To use in your project, import the 'pbSettings.bas' module, and the 'Dictionary.cls' class module (also available here). Calling a method will automatically set up the worksheet/listobject. (e.g. t ype '? pbSettings.KeyExists("Version")' in the Immediate Window)
-
Map and Copy Rows from ListObjects or Range to a 'Master' ListObject or Range
Download Demo .xlsm File
crypto_vba
-
VBA API call with nested JSON data
It basically uses the Dictionary object to create variables (e.g. with a dictionary in a dictionary) and after that using that library to transform it into a string. I'm using it in my project here: https://github.com/krijnsent/crypto_vba/blob/master/ModExchKucoin.bas
-
Where should I store API Keys?
I agree with u/sslinky84 that there is no safe place in VBA. The main question is: what's the purpose of an API key in this case? From your description you are not linking an API-key to a single user, but have "one key to rule them all". So you probably want to prevent someone from grabbing your end-point and spamming it? In that case you're perfectly fine in creating one API-string in VBA and checking that on the server: it blocks the person who is opening a browser to fiddle with your end-point, but it does give you some security. The people who can get through are the ones that manage to crack open your VBA (assuming you have a password on the VBA). To make their life a bit harder you could instead of a "fixed string" as API key go for some kind of hash, as u/archn suggests. E.g.: take the rest of the post message that e.g. also includes a mandatory timestamp, make a simple hash of that (might even include a "fixed key", see e.g. https://github.com/krijnsent/crypto_vba/blob/master/ModHash.bas for some code).
-
Self made Excel/VBA triggers virus scan - what to do?
I've built an open source VBA-Excel library to communicate with cryptocurrency exchanges ( https://github.com/krijnsent/crypto_vba ) and have my code available as .bas and in an .xlsm file. A couple of days ago someone posted an issue that my xlsm file triggered a Windows defender alert. At my pc this doesn't happen, the AVG virus scanner also won't show anything.
-
How to import price actions with API from CoinGecko
I am mainly using Cryptocompare, but if you want to use CoinGecko, check out my code, it has the basics: https://github.com/krijnsent/crypto_vba/ It has most of the essentials: connecting Excel to web, handling Json and some API examples.
What are some alternatives?
VBA-Dictionary - Drop-in replacement for Scripting.Dictionary on Mac [Moved to: https://github.com/VBA-tools/VBA-Dictionary]
crypto-trading-bot - Cryptocurrency trading bot in javascript for Bitfinex, Bitmex, Binance, Bybit ... (public edition)
VBA - Code Blocks relating to everything VBA
ccxws - WebSocket client for 38 cryptocurrency exchanges
stdVBA - VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications.
VBA-JSON-parser - Backus-Naur Form JSON Parser based on RegEx for VBA
VBA-Dictionary - Drop-in replacement for Scripting.Dictionary on Mac
QueryCsvToExcel - Provides VBA code for executing a SQL query on a CSV file to import data into a worksheet in Excel
VBA-StateLossCallback - A class that allows a callback when state is lost
Export-MS-Project-to-MS-Excel - Export tasks, Gantt chart and resources from MS Project to MS Excel. No additional software or installation required. Using build-in MS Project features (VBA).
coinbasepro-python - The unofficial Python client for the Coinbase Pro API
VBA-JSON - JSON conversion and parsing for VBA