Connect MIDI piano to Excel

[RishiA]

Hi all,

This is my first post.

I want to be able to play a single note on my piano and have Excel play it and show me which note I'm playing in real-time (e.g. a C or G etc).

As I see it, this would require the following steps:
1. Have Excel recognize my piano MIDI signals
2. Store the MIDI info sent from the piano in Excel
3. Convert this info to sound and text (i.e. the note to be displayed)
4. Display the note in a cell on the spreadsheet

I'm hoping that this can be done, but have no clue as to how. Also; I have no experience with VBA or MIDI processing, but some experience with programming. If you post any code, would you mind making your explanation noob-friendly?

Thanks,
Rishi

 

[Cool blue]

For me, you know, I would think that doing battle with the API calls for the midi services would be a better strategy.
Im sure there are quite a few layers of abstraction between the USB and midi services.
I had a bit if a read of the API calls and I don't really have a reason to really figure it out but that would be my thoughts for what it's worth.

I think it's a fun idea though, what you are doing.
I have produced midi files in excel before. I have some applications for automatically generating appropriate 4 note chords to provide very simple context for practicing scales. So, for example, if you want to practice your mixolydian scales, back cycling in fourths, it produces a nicely voiced sequence of chords to give your ear context for each scale.
Im an interested bystander for your efforts. It's a pitty I don't have time to help.