I'd been planning on setting up a AIO excel solution for my trading. Intending for it to do market scans, allow me to trade from it, add trades to a journal and monitor my portfolio all from a few sheets. Could you elaborate on why you think it's a bad idea? Don't want to waste my time. Thanks.
Stability and readability. While ActiveX stuff is fairly stable, it still has odd issues from time to time. With a proper language, as long as you don't change something, it will keep working without problem.
If what you create is reasonably complex, trying to find or modify anything will be a massive pain.
Since you will place the trades yourself, it's not as bad but I wouldn't let it run unsupervised.
I used both the DDE and ActiveX versions. DDE was garbage, ActiveX was usable but "flimsy".