MIDI-OX User Forum - Print Page


    
      
        MIDI-OX User Forum
        (http://www.midiox.com/cgi-bin/yabb/YaBB.pl)
      

        MIDI-OX >> Scripting Questions >> Send Sysex from Excel
        
(Message started by: Kilroy_56 on Apr 16^th, 2020, 9:20pm)

Title: Send Sysex from Excel
Post by Kilroy_56 on Apr 16^th, 2020, 9:20pm

I have developed a programmer for my JL Cooper MSB + rev2 in an Excel spreadsheet. I have reached the point where I can get an entire data dump into a (large)cell. I can start midi ox from the macro and even copy and paste the dump to the sysex window to send (which I have to do manually). I'd like to automate this process with scripting but not sure where to start.

Title: Re: Send Sysex from Excel
Post by Breath on Apr 18^th, 2020, 10:59pm

I read this and thought what a brave soul you must be wrestling with MS macros, but we all use what we know, I guess.
There is a section in Help devoted to scripting. Open Help / Scripting Interface

Stay well
Royce

Title: Re: Send Sysex from Excel
Post by Kilroy_56 on Apr 19^th, 2020, 1:21am

Thanks for the reply. Yes, the macro road is tedious and nerve wracking at times. I read all the help inserts on scripting that come with the program and here in the forum. I still can't get a claw in the rug. Thanks for the reply. I'll keep working on it.

Title: Re: Send Sysex from Excel
Post by Breath on Apr 19^th, 2020, 2:40am

I guess you have seen all the examples that are in ./MIDIOX/WHS

You can use Visual Basic in Excel, as I recall, and there are a couple of good VB examples Jamie has included.

Perhaps that is the way to go.

Title: Re: Send Sysex from Excel
Post by Kilroy_56 on Apr 19^th, 2020, 2:42am

I will check that out. Thanks a lot. :)

Title: Re: Send Sysex from Excel
Post by thomasa on May 26^th, 2020, 5:21am

Hi!

I'm sending sysex messages from Excel in a microtuning application. The sysex messages are MTS strings (MTS = Midi Tuning Standard) that retunes/resets separate and single notes according to a table and the bass note. MTS is a more flexible way to microtune than to use pitch bend which affects all notes in a channel. Unfortunately there are not many softsynths that are MTS-aware.

Check out a short example:

https://www.youtube.com/watch?v=UGuv92UOg4k&t=115s

Please feel free to contact me if you think I can be of some help.

/Thomas

Title: Re: Send Sysex from Excel
Post by Breath on May 26^th, 2020, 9:29pm

Thanks Thomas.
Great idea.
I am always astounded by what people can do with MidiOx.

All the best
Royce