VBAChromeDevProtocol
pip
VBAChromeDevProtocol | pip | |
---|---|---|
9 | 108 | |
53 | 9,282 | |
- | 0.6% | |
0.0 | 9.8 | |
over 1 year ago | 4 days ago | |
VBA | Python | |
MIT License | 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.
VBAChromeDevProtocol
-
TabFS – a browser extension that mounts the browser tabs as a filesystem
I used to scan all the tabs in open browser windows to preserve all open URLs.
See also https://chromedevtools.github.io/devtools-protocol/ with Playwright et. al., even Excel VBA: https://github.com/PerditionC/VBAChromeDevProtocol
- The First Rule of Microsoft Excel: Don’t Tell Anyone You’re Good at It
-
Chrome Automation without Selenium
Use dev tools protocol
-
What problems have you solved with VBA?
Automating chrome via accessibility or via devtools protocol
-
Is .jsEval part of vanilla VBA or from a library of some sort? I googled and absolutely nothing came up in regards to this method.
If you're interested in XPath/ QuerySelectors, there is another VBA + Chrome project on Github which seeks to do much the same thing, though I haven't looked to see if there is jsEval equivalent, though there might be. But it definitely allows for QuerySelection of DOM elements; the following is an example from the project:
- IE automation with VBA
- Looking for something to do
- VBA And The WebDriver Dilemma
- [EXCEL] VBA Macro integration with Chrome.
pip
-
How to Create Virtual Environments in Python
Whenever you are working on a Python project that has external dependencies installed with pip, it is strongly recommended to first create a virtual environment.
-
Boring Python: dependency management (2022)
Unfortunately that feature is easy to break: https://github.com/pypa/pip/issues/9644
-
pip VS instld - a user suggested alternative
2 projects | 9 Dec 2023
-
sudo pip install should be illegal
I think I did my part https://github.com/pypa/pip/issues/6409
-
Can't seem to install Python YAML support
$ sudo pip install y$ sudo pip install yaml WARNING: pip is being invoked by an old script wrapper. This will fail in a future version of pip. Please see https://github.com/pypa/pip/issues/5599 for advice on fixing the underlying issue. To avoid this problem you can invoke Python with '-m pip' instead of running pip directly. ERROR: Could not find a version that satisfies the requirement yaml (from versions: none) ERROR: No matching distribution found for yaml
-
Bun v0.6.0 – Bun's new JavaScript bundler and minifier
What are you implying will happen?
Using the build-in tools, you can save the exact versions of dependencies (i.e. a lock file) using "pip freeze >dependencies.txt". This should give you the exact same set of packages in two years' time.
If you want to be even more sure, you can also store hashes in the lock file. This has to be generated by a separate tools at the moment [1][2] but can be consumed by the built-in tools [3], so "pip install -r requirements.txt" is still all you need in two years' time.
[1] https://github.com/pypa/pip/issues/4732
[2] https://pip-tools.readthedocs.io/en/latest/#using-hashes
[3] https://pip.pypa.io/en/stable/topics/secure-installs/#hash-c...
-
My Goldilocks Python Setup: pyenv, pipx, and pip-tools
Here’s the issue, https://github.com/pypa/pip/issues/11664. I think the idea would be to have some file/json description of environment that could be passed to pip to allow it to fully cross compile. They are open to supporting it just needs contributor to be found to implement it and go through review/discussion.
-
Remote Code Execution Vulnerability in Google They Are Not Willing to Fix
To be fair the only alternative is fixing Python, and even then you still would have to wait a good 5 years at least for all the old Python versions to dwindle.
It doesn't look like the fixing effort is progressing very quickly: https://github.com/pypa/pip/issues/8606
To their credit, at least they didn't close it "works as intended" which I imagine a lot of projects would.
-
Pip 23.1 Released - Massive improvement to backtracking
Another good benchmark to trying to resolve apache-airflow[all]==1.10.13 using the state of PyPi on 2020-12-02, I give instructions here on how to reproduce that workflow: https://github.com/pypa/pip/issues/11836. Including a benchmark how how many extra packages your resolver should visit.
- will upgrading pip break things?
What are some alternatives?
stdVBA - VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications.
mamba - The Fast Cross-Platform Package Manager
VBA-Web - VBA-Web: Connect VBA, Excel, Access, and Office for Windows and Mac to web services and the web
Poetry - Python packaging and dependency management made easy
stdVBA-examples
PDM - A modern Python package and dependency manager supporting the latest PEP standards
go-xdr - An XDR (External Data Representation) to Go compiler
conda - A system-level, binary package and environment manager running on all major operating systems and platforms.
integrate-palm-into-word - How to use Google's PaLM 2 language model in Microsoft Word.
pip-tools - A set of tools to keep your pinned Python dependencies fresh.
osa-chrome - Emacs remote tab control for Google Chrome
wheel - Adoption analysis of Python Wheels: https://pythonwheels.com/