Hi there,
I can read your project and it is interesting. I work with Interactive Brokers every day as most of my projects are built with that Broker's API. So, it will surely be a simple project. I am an IT engineer and I work exclusively with Financial Market projects.
In your specific case it is relatively simple. First, a suggestion I may give you, is to get rid of Excel, you can build a custom, decent and sleek application in Java/C# for almost the same price and retrieve all that information you require from prices to all fundamental stats for the selected symbol or list of symbols. If you want, I can send you some pictures of solutions like this one you require which work with Interactive Brokers and extract all available information for the selected symbol(s). Not to mention, that you can also automate your trades, manage your Pending Orders and your current Positions.
However, if you really need to work with Excel, then the solution is similar as the API calls are the same regardless if the language used. And in the end, I would be sending you the raw VB code you described.
I placed 7 days on my bid, 5 to deliver your project and 2 more just in case you need anything else.
Regards,
Eng. John P.