This repository contains the code for Excel POST, a series of self-service macros in Excel VBA that allows a user to submit spreadsheet data to a system's web form via HTTP POST requests.
- Developer: Madison Eichberg
- License: MIT Licensing (Open Source)
- Language: VBA
- Latest Version: 02/20/2020
Setup the file once with a few quick steps:
- Change Excel settings to allow you to read/write macros
- Setup your spreadsheet's column headers for easy posting
- Configure your POST URL so that it points to your system's form and retrieves entered data
- Update your security settings (optional)
After setup, a user can run the following commands via a click of a button:
- Reset the spreadsheet back to its startup settings
- Construct URLs based on entered spreadsheet data
- POST the URLs to a designated system
- Stop the code from running at the user's command
To get started, download Excel POST and see configuration instructions.
Happy POSTing!