Thanks guys.
So I'm really interested in:
- Python
- VBA
- C Sharp
Each for their own reasons. I think I'll pick two (but I'll start with one).
Which is best to do these things with excel (for personal use):
- Create a menu interface which can be used as the central command system which links between excel (multiple excel files), the user (me), and word or text files as well. The menu interface is where commands would be made.
- Read excel so that I can do reads/writes of existing files. For example, I'd like to design my own conditions for reading journal entries. Or for reading a trial balance. Since formatting can range, I'd need to be able to read positioning, and all details about each cell (ex. if it's part of a table, and so on and so forth). If I edit that excel file instead of just pull the data, I'd need to be able to read a full range of information.
- If I'm writing a fresh excel file, I'd need full access to all commands. If I pulled information from an excel file, I'd like to be able to sort, analyse, etc, and then write according to my specification.
The core of what I want to start is basic ways of reading and storing information (the way I want to store it). From there I want to add on ways to read information conditionally, ways to sort information within my own system, and various macroscopic tasks.
This post was edited by Canadian_Man on May 4 2017 07:11pm