I have list of stock codes in Excel and I am trying (unsuccesfully) to make vba code to:
1. Grab the first stock code in the column > enter
2. Open 'Big Charts' and paste the stock code in there......or is it easier to concatenate the code into the url in an adjacent cell and let Excel activate it ..... ? > enter
3. Let me view the chart and open a comment box for me to make a small note > enter
4. Paste the comment in a cell next to that stock > enter
5. Move down to the next stock and repeat the process.... (there are hundreds of them!)
Then I have a printable record of what I saw in that session, and I can add or remove codes from the list ready for the next session.
Any help will be greatly appreciated.