I would like to ask experienced VBA programmers if my proposed app will fit under the VBA umbrella, or if I should look elsewhere. I am looking for general “can do | no can do” responses. Of course, I am trying to avoid investing many hours of research into VBA inner workings, only to arrive at “No can do”. Being willing to pay for helpful tools, I wrote Windmill Software to see if their offerings might help, but they either no longer exist or are simply not response-able.
The app requires me to read a rotary encoder on a USB port (It comes with VBA example code). When the encoder says we are at the next data point, I read a digital meter on another USB port, convert reading to engineering units, and pass the encoder and meter data to Excel in real time. Excel then plots these data on a scrolling graph in real time. I would like to know if experienced VBA folks see any fatal “gotchas” in this plan. I would also appreciate any suggestions concerning newbie level tutorials and|or third party tools which would help me to avoid “re-inventing the wheel” in developing this app. Any input on the advisability of going down the VBA/Excel road would be very much appreciated. I have experience in VB (not VBA) and Excel.
Thanks in advance for your input on this subject.