Author |
Topic: Send Sysex from Excel (Read 2159 times) |
|
Kilroy_56
New Member
MIDI-OX Rules!
Posts: 3
|
 |
Send Sysex from Excel
« on: Apr 16th, 2020, 9:20pm » |
 Quote  Modify
|
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.
|
|
 IP Logged |
|
|
|
Breath
Administrator
Gender: 
Posts: 1030
|
|
Re: Send Sysex from Excel
« Reply #1 on: Apr 18th, 2020, 10:59pm » |
Quote Modify
|
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
|
|
IP Logged |
|
|
|
Kilroy_56
New Member
MIDI-OX Rules!
Posts: 3
|
|
Re: Send Sysex from Excel
« Reply #2 on: Apr 19th, 2020, 1:21am » |
Quote Modify
|
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.
|
|
IP Logged |
|
|
|
Breath
Administrator
Gender:
Posts: 1030
|
|
Re: Send Sysex from Excel
« Reply #3 on: Apr 19th, 2020, 2:40am » |
Quote Modify
|
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.
|
|
IP Logged |
|
|
|
Kilroy_56
New Member
MIDI-OX Rules!
Posts: 3
|
|
Re: Send Sysex from Excel
« Reply #4 on: Apr 19th, 2020, 2:42am » |
Quote Modify
|
I will check that out. Thanks a lot. 
|
|
IP Logged |
|
|
|
thomasa
New Member
MIDI-OX Rules!
Posts: 1
|
|
Re: Send Sysex from Excel
« Reply #5 on: May 26th, 2020, 5:21am » |
Quote Modify
|
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
|
|
IP Logged |
|
|
|
Breath
Administrator
Gender:
Posts: 1030
|
|
Re: Send Sysex from Excel
« Reply #6 on: May 26th, 2020, 9:29pm » |
Quote Modify
|
Thanks Thomas.
Great idea.
I am always astounded by what people can do with MidiOx.
All the best
Royce
|
|
IP Logged |
|
|
|
|
User Forum ::
Powered by YaBB
Home 
Help 
Search 
Members 
Login 
Register
Reply
Notify of replies
Send Topic
Print