|
Log in to post
|
Print Thread |
|
|
|
|
|
Off-Topic
|
Joined: Nov 2005
Posts: 479
Journeyman
|
OP
Journeyman
Joined: Nov 2005
Posts: 479 |
I have a bunch of scales and modes info (like a list of note names C D E ... for each scale) stored in an Excel spread sheet. I'd like to hear each of these scales played in midi, preferably by just clicking any one at will. Of course, I could convert the list to midi note numbers or any other form. I can't see a way to get excel to play midi. So does anyone know of a way to get Excel to play midi, or any way to copy and paste Excel data like this to some other program that could. I don't want to manually enter the notes into BIAB or other sequencer. Thanks for any insights.
kelso
Dell Desktop XPS 8100 W10 HomePrem/64 / Core i5 760 (quad, 2.8GHz) / 8GB DDR3 / 1 TB SATA / ViewSonic VG2428wm / EMU1616 PCI / Event ASP6 Active Monitors / BIAB 2019 64 bit (609) / Cakewalk
|
|
|
|
|
|
|
|
|
|
|
|
|
Off-Topic
|
Joined: Dec 2007
Posts: 1,439
Expert
|
|
Expert
Joined: Dec 2007
Posts: 1,439 |
--=-- My credo: If it's worth doing, it's worth overdoing - just ask my missus, she'll tell ya  --=--You're only paranoid if you're wrong!
|
|
|
|
|
|
|
|
|
|
|
|
|
Off-Topic
|
Joined: Jan 2002
Posts: 7,913
Veteran
|
|
Veteran
Joined: Jan 2002
Posts: 7,913 |
If you know any visual basic programming (VBA for example that ships with MSOffice products), you could interface with with the API that allows you to do this. There are several 3rd party programs which will allow you to hook to the midi instructions to play the notes you have in your files. FMOD is one that I used very briefly in my previous employment: http://www.fmod.org/index.php/downloadIf you don't know VB programming, or any programming for that matter, then I'm afraid I don't have an answer for you. -Scott
|
|
|
|
|
|
|
|
|
|
|
|
|
Off-Topic
|
Joined: May 2005
Posts: 222
Apprentice
|
|
Apprentice
Joined: May 2005
Posts: 222 |
kelsoz
Probably the easiest way to accomplish your goal without any VBA programming would be to do the following.
1. Use Biab to produce a midi file playing the notes of each selection.
2. In Excel, create a hyperlink to the appropriate midi file in the 1st cell of each selection.
When you click the link the cell will play.
BTW:
1. This will also work with mgu and sgu hyperlinks, but will launch Biab when clicked.
2. For those of you who use Biab for gigs, using Excel and this method provides another way to create "playable" set lists that can be easily edited. Open Biab in the top half of you screen and your Excel playlist in the bottom half and you are in business.
Hope this helps.
Blatz
________
Lawrie
Thanks for the DailydoseofExcel.com link.
Last edited by JBlatz; 05/21/09 09:51 AM.
JBlatz
|
|
|
|
|
|
|
|
|
|
|
|
|
Off-Topic
|
Joined: Nov 2005
Posts: 479
Journeyman
|
|
OP
Journeyman
Joined: Nov 2005
Posts: 479 |
Thanks Blatz - but if I'm hearing you, this will do the opposite of what. I don't want to trigger Excel to play a biab or midi file. I have a hundreds of scales in an excel sheet. In my dream world, I want to click in the excel cell to play any one of the scales.
If I had a life time, I would just program each scale into biab or any sequencer and play from there. The trick it to get some program (excel, biab, ....) to read the excel sheet. I would also be happy to copy/paste all the data from excel to some program that would recognize and play the scale sequences.
In the good old Commodore 64 days I could do this in basic.
kelso
Dell Desktop XPS 8100 W10 HomePrem/64 / Core i5 760 (quad, 2.8GHz) / 8GB DDR3 / 1 TB SATA / ViewSonic VG2428wm / EMU1616 PCI / Event ASP6 Active Monitors / BIAB 2019 64 bit (609) / Cakewalk
|
|
|
|
|
|
|
|
|
|
|
|
|
Off-Topic
|
Joined: May 2000
Posts: 38,502
Veteran
|
|
Veteran
Joined: May 2000
Posts: 38,502 |
If you learned them, then you wouldn't have to program them.
While there may appear to be *hundreds* in your spreadsheet, that is not really the case.
Investigate the Tetrachords, which are the four-note groups by all possibilities of half, whole and 1-1/2 steps for every four notes and then understand that any scale is but a combination of any of the two Tetrachords.
If you don't have time to program them, you don't have time to learn 'em anyway, so what's the point? Just being able to play back hundreds of scale or mode possibilities won't help here either.
--Mac
|
|
|
|
|
|
|
|
|
|
|
|
|
Off-Topic
|
Joined: Sep 2007
Posts: 3,926
Veteran
|
|
Veteran
Joined: Sep 2007
Posts: 3,926 |
Why do I think this is how BIAB started?
R.
"My primary musical instrument is the personal computer."
|
|
|
|
|
|
|
|
|
|
|
|
|
Off-Topic
|
Joined: May 2000
Posts: 38,502
Veteran
|
|
Veteran
Joined: May 2000
Posts: 38,502 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Off-Topic
|
Joined: Nov 2005
Posts: 479
Journeyman
|
|
OP
Journeyman
Joined: Nov 2005
Posts: 479 |
What makes you think I want to learn them? I am a musician, physicist, and number freak. I just want to explore, group by common elements, compare with chords, etc. And I have some other applications. It's just a hobby. While I appreciate your always-helpful approach on this and other forums, ignoring my query and suggesting a solution to some other problem is not real helpful. So, do you have any ideas to get a list of scale data in excel to play a midi sequence?
|
|
|
|
|
|
|
|
|
|
|
|
|
Off-Topic
|
Joined: May 2005
Posts: 222
Apprentice
|
|
Apprentice
Joined: May 2005
Posts: 222 |
Your welcome, kelsoz.
I was only trying to suggest a method that did not require VBA programming. Since you mentioned you were familiar with basic and VBA is Visual Basic, might I suggest examining the information contained on the great "dailydoseofexcel" link Lawrie provided. I bookmarked the page and downloaded John Walkenbach's "midi-player.xls", but I'm on my internet linux machine and haven't had time to transfer it to Windows and examine it in Excel. However, from what I've seen in Open Office on this Pc, it looks like it might provide you with the copy & paste functionality you seek. Also, one nice thing about using Excel and VBA is that you can always change the program and the spreadsheet to your specifications.
J Blatz
JBlatz
|
|
|
|
|
|
|
|
|
|
|
|
|
Off-Topic
|
Joined: May 2000
Posts: 38,502
Veteran
|
|
Veteran
Joined: May 2000
Posts: 38,502 |
I just couldn't fathom why you wanted to hear them...
==Mac
|
|
|
|
|
|
|
|
|
|
|
|
|
Off-Topic
|
Joined: Nov 2005
Posts: 479
Journeyman
|
|
OP
Journeyman
Joined: Nov 2005
Posts: 479 |
So why not ask "Why?" instead of dismissing my request for some help?
kelso
Dell Desktop XPS 8100 W10 HomePrem/64 / Core i5 760 (quad, 2.8GHz) / 8GB DDR3 / 1 TB SATA / ViewSonic VG2428wm / EMU1616 PCI / Event ASP6 Active Monitors / BIAB 2019 64 bit (609) / Cakewalk
|
|
|
|
|
|
|
|
|
|
|
|
|
Off-Topic
|
Joined: May 2000
Posts: 38,502
Veteran
|
|
Veteran
Joined: May 2000
Posts: 38,502 |
Look, I am sorry if you think what I said was a dismissal.
I tend to think as a musician about such things and I freely shared with you what I know to be the best way for a musician to approach the subject.
--Mac
|
|
|
|
|
|
|
|
|
|
|
|
|
Off-Topic
|
Joined: Nov 2005
Posts: 479
Journeyman
|
|
OP
Journeyman
Joined: Nov 2005
Posts: 479 |
Thanks Mac - I was a little prickly as well. I used to write little sequencer and patch editing programs for the Commodore 64 and Amiga before there was much out there. Being a scientist/engineer, I am inclined to categorize, chart, and graph everything, and this tendency lends itself well to music. So I am sometimes happy to spend many hours sifting through data and when finished, have nothing of value to show for it. So scales, chords, microtonality and tunings, wave forms, and on and on give me endless hours of entertainment. Then I also try to play a little jazz and pop.
BTW, I have found some programs characterized as "text to midi" that are aimed at doing what I want. But, so far, it appears that they are all DOS based, and not that usable.
Later,
Last edited by kelso; 05/22/09 06:53 AM.
kelso
Dell Desktop XPS 8100 W10 HomePrem/64 / Core i5 760 (quad, 2.8GHz) / 8GB DDR3 / 1 TB SATA / ViewSonic VG2428wm / EMU1616 PCI / Event ASP6 Active Monitors / BIAB 2019 64 bit (609) / Cakewalk
|
|
|
|
|
|
|
|
|
|
|
|
|
Off-Topic
|
Joined: Jul 2007
Posts: 888
Expert
|
|
Expert
Joined: Jul 2007
Posts: 888 |
I have sent a PM that may lead to a solution. Check your mail box.
PM
|
|
|
|
|
|
|
|
|
|
|
|
|
Off-Topic
|
Joined: Jul 2007
Posts: 888
Expert
|
|
Expert
Joined: Jul 2007
Posts: 888 |
For those who might be interested.
I have about 80 per cent of the code worked out for routines in excel that will play midi info as defined in john original post.
It would be something that you could play around with riffs and scales in excel. It allows you to define a note patter (scale or riff) a play pattern (a combination of volume and durations), select a midi player form your system, and a midi patch.
Not really sure it will have much in the way interest to most users. John presented it as something he was looking for and I had written much of the code years ago when I was first looking at midi and have begun to wrap that code into a package that actually does something useful, we, useful for at least on user's interest.
It is written in VB/VBA and so may be of some interest to people playing around in that particular environment.
Have a good one.
PM
|
|
|
|
|
|
|
|
|
|
|
|
|
Off-Topic
|
Joined: Jul 2007
Posts: 888
Expert
|
|
Expert
Joined: Jul 2007
Posts: 888 |
Quote:
For those who might be interested.
I have about 80 per cent of the code worked out for routines in excel that will play midi info as defined in john original post.
It would be something that you could play around with riffs and scales in excel. It allows you to define a note patter (scale or riff) a play pattern (a combination of volume and durations), select a midi player form your system, and a midi patch.
Not really sure it will have much in the way interest to most users. John presented it as something he was looking for and I had written much of the code years ago when I was first looking at midi and have begun to wrap that code into a package that actually does something useful, we, useful for at least on user's interest.
It is written in VB/VBA and so may be of some interest to people playing around in that particular environment.
Have a good one.
I should have noted, I have the working version, that plays midi from excel, and am 80 done a version with a user interface that allows determining how the scale/riffs in excel are played. Patch change, duration of notes, volumns, midi player, etc. etc.
PM
|
|
|
|
|
|
|
|
|
|
|
|
Ask sales and support questions about Band-in-a-Box using natural language.
ChatPG's knowledge base includes the full Band-in-a-Box User Manual and sales information from the website.
|
|
|
|
|
|
|
|
|
|
|
New RealTracks Released with Band-in-a-Box 2025!
We’ve expanded the Band-in-a-Box® RealTracks library with 202 incredible new RealTracks (in sets 449-467) across Jazz, Blues, Funk, World, Pop, Rock, Country, Americana, and Praise & Worship—featuring your most requested styles!
Jazz, Blues & World (Sets 449–455):
These RealTracks includes “Soul Jazz” with Neil Swainson (bass), Mike Clark (drums), Charles Treadway (organ), Miles Black (piano), and Brent Mason (guitar). Enjoy “Requested ’60s” jazz, classic acoustic blues with Colin Linden, and more of our popular 2-handed piano soloing. Plus, a RealTracks first—Tango with bandoneon, recorded in Argentina!
Rock & Pop (Sets 456–461):
This collection includes Disco, slap bass ‘70s/‘80s pop, modern and ‘80s metal with Andy Wood, and a unique “Songwriter Potpourri” featuring Chinese folk instruments, piano, banjo, and more. You’ll also find a muted electric guitar style (a RealTracks first!) and “Producer Layered Guitar” styles for slick "produced" sound.
Country, Americana & Praise (Sets 462–467):
We’ve added new RealTracks across bro country, Americana, praise & worship, vintage country, and songwriter piano. Highlights include Brent Mason (electric guitar), Eddie Bayers (drums), Doug Jernigan (pedal steel), John Jarvis (piano), Glen Duncan (banjo, mandolin & fiddle), Mike Harrison (electric bass) and more—offering everything from modern sounds to heartfelt Americana styles
Check out all the 202 New RealTracks (in sets 456-467)
And, if you are looking for more, the 2025 49-PAK (for $49) includes an additional 20 RealTracks with exciting new sounds and genre-spanning styles. Enjoy RealTracks firsts like Chinese instruments (guzheng & dizi), the bandoneon in an authentic Argentine tango trio, and the classic “tic-tac” baritone guitar for vintage country.
You’ll also get slick ’80s metal guitar from Andy Wood, modern metal with guitarist Nico Santora, bass player Nick Schendzielos, and drummer Aaron Stechauner, more praise & worship, indie-folk, modern/bro country with Brent Mason, and “Songwriter Americana” with Johnny Hiland.
Plus, enjoy user-requested styles like Soul Jazz RealDrums, fast Celtic Strathspey guitar, and Chill Hop piano & drums!
The 2025 49-PAK is loaded with other great new add-ons as well. Learn more about the 2025 49-PAK!
Bonus PAKs for Band-in-a-Box 2025 for Mac!
With your version 2025 for Mac Pro, MegaPAK, UltraPAK, UltraPAK+, Audiophile Edition or PlusPAK purchase, we'll include a Bonus PAK full of great new Add-ons FREE! Or upgrade to the 2025 49-PAK for only $49 to receive even more NEW Add-ons including 20 additional RealTracks!
These PAKs are loaded with additional add-ons to supercharge your Band-in-a-Box®!
This Free Bonus PAK includes:
- The 2025 RealCombos Booster PAK:
-For Pro customers, this includes 33 new RealTracks and 65+ new RealStyles.
-For MegaPAK customers, this includes 29 new RealTracks and 45+ new RealStyles.
-For UltraPAK customers, this includes 20 new RealStyles.
- Look Ma! More MIDI 13: Country & Americana
- Instrumental Studies Set 22: 2-Hand Piano Soloing - Rhythm Changes
- MIDI SuperTracks Set 44: Jazz Piano
- Artist Performance Set 17: Songs with Vocals 7
- Playable RealTracks Set 4
- RealDrums Stems Set 7: Jazz with Mike Clark
- SynthMaster Sounds and Styles (with audio demos)
- 128 GM MIDI Patch Audio Demos.
Looking for more great add-ons, then upgrade to the 2025 49-PAK for just $49 and you'll get:
- 20 Bonus Unreleased RealTracks and RealDrums with 20 RealStyles,
- FLAC Files (lossless audio files) for the 20 Bonus Unreleased RealTracks and RealDrums
- Look Ma! More MIDI 14: SynthMaster,
- Instrumental Studies Set 23: More '80s Hard Rock Soloing,
- MIDI SuperTracks Set 45: More SynthMaster
- Artist Performance Set 18: Songs with Vocals 8
- RealDrums Stems Set 8: Pop, Funk & More with Jerry Roe
Learn more about the Bonus PAKs for Band-in-a-Box® 2025 for Mac®!
New! Xtra Styles PAK 20 for Band-in-a-Box 2025 and Higher for Mac!
Xtra Styles PAK 20 for Mac & Windows Band-in-a-Box version 2025 (and higher) is here with 200 brand new RealStyles!
We're excited to bring you our latest and greatest in the all new Xtra Styles PAK 20 for Band-in-a-Box! This fresh installment is packed with 200 all-new styles spanning the rock & pop, jazz, and country genres you've come to expect, as well as the exciting inclusion of electronic styles!
In this PAK you’ll discover: Minimalist Modern Funk, New Wave Synth Pop, Hard Bop Latin Groove, Gospel Country Shuffle, Cinematic Synthwave, '60s Motown, Funky Lo-Fi Bossa, Heavy 1980s Metal, Soft Muted 12-8 Folk, J-Pop Jazz Fusion, and many more!
All the Xtra Styles PAKs 1 - 20 are on special for only $29 each (reg $49), or get all 209 PAKs for $199 (reg $399)! Order now!
Learn more and listen to demos of the Xtra Styles PAK 20.
Video: Xtra Styles PAK 20 Overview & Styles Demos: Watch now!
Note: The Xtra Styles require the UltraPAK, UltraPAK+, or Audiophile Edition of Band-in-a-Box®. (Xtra Styles PAK 20 requires the 2025 or higher UltraPAK, UltraPAK+, or Audiophile Edition. They will not work with the Pro or MegaPAK version because they need the RealTracks from the UltraPAK, UltraPAK+, or Audiophile Edition.
New! XPro Styles PAK 9 for Band-in-a-Box 2025 and higher for Mac!
We've just released XPro Styles PAK 9 for Mac & Windows Band-in-a-Box version 2025 (and higher) with 100 brand new RealStyles, plus 29 RealTracks/RealDrums!
We've been hard at it to bring you the latest and greatest in this 9th installment of our popular XPro Styles PAK series! Included are 75 styles spanning the rock & pop, jazz, and country genres (25 styles each) that fans have come to expect, as well as 25 styles in this volume's wildcard genre: funk & R&B!
If you're itching to get a sneak peek at what's included in XPro Styles PAK 9, here is a small helping of what you can look forward to: Funky R&B Horns, Upbeat Celtic Rock, Jazz Fusion Salsa, Gentle Indie Folk, Cool '60s Soul, Funky '70s R&B, Smooth Jazz Hip Hop, Acoustic Rockabilly Swing, Funky Reggae Dub, Dreamy Retro Latin Jazz, Retro Soul-Rock Fusion, and much more!
Special Pricing! Until July 31, 2024, all the XPro Styles PAKs 1 - 9 are on sale for only $29 ea (Reg. $49 ea), or get them all in the XPro Styles PAK Bundle for only $149 (reg. $299)! Order now!
Learn more and listen to demos of XPro Styles PAKs.
Video: XPro Styles PAK 9 Overview & Styles Demos: Watch now!
XPro Styles PAKs require Band-in-a-Box® 2025 or higher and are compatible with ANY package, including the Pro, MegaPAK, UltraPAK, UltraPAK+, and Audiophile Edition.
New! Xtra Styles PAK 20 for Band-in-a-Box 2025 and Higher for Windows!
Xtra Styles PAK 20 for Windows & Mac Band-in-a-Box version 2025 (and higher) is here with 200 brand new RealStyles!
We're excited to bring you our latest and greatest in the all new Xtra Styles PAK 20 for Band-in-a-Box! This fresh installment is packed with 200 all-new styles spanning the rock & pop, jazz, and country genres you've come to expect, as well as the exciting inclusion of electronic styles!
In this PAK you’ll discover: Minimalist Modern Funk, New Wave Synth Pop, Hard Bop Latin Groove, Gospel Country Shuffle, Cinematic Synthwave, '60s Motown, Funky Lo-Fi Bossa, Heavy 1980s Metal, Soft Muted 12-8 Folk, J-Pop Jazz Fusion, and many more!
All the Xtra Styles PAKs 1 - 20 are on special for only $29 each (reg $49), or get all 209 PAKs for $199 (reg $399)! Order now!
Learn more and listen to demos of the Xtra Styles PAK 20.
Video: Xtra Styles PAK 20 Overview & Styles Demos: Watch now!
Note: The Xtra Styles require the UltraPAK, UltraPAK+, or Audiophile Edition of Band-in-a-Box®. (Xtra Styles PAK 20 requires the 2025 or higher UltraPAK, UltraPAK+, or Audiophile Edition. They will not work with the Pro or MegaPAK version because they need the RealTracks from the UltraPAK, UltraPAK+, or Audiophile Edition.
New! XPro Styles PAK 9 for Band-in-a-Box 2025 and higher for Windows!
We've just released XPro Styles PAK 9 for Windows & Mac Band-in-a-Box version 2025 (and higher) with 100 brand new RealStyles, plus 29 RealTracks/RealDrums!
We've been hard at it to bring you the latest and greatest in this 9th installment of our popular XPro Styles PAK series! Included are 75 styles spanning the rock & pop, jazz, and country genres (25 styles each) that fans have come to expect, as well as 25 styles in this volume's wildcard genre: funk & R&B!
If you're itching to get a sneak peek at what's included in XPro Styles PAK 9, here is a small helping of what you can look forward to: Funky R&B Horns, Upbeat Celtic Rock, Jazz Fusion Salsa, Gentle Indie Folk, Cool '60s Soul, Funky '70s R&B, Smooth Jazz Hip Hop, Acoustic Rockabilly Swing, Funky Reggae Dub, Dreamy Retro Latin Jazz, Retro Soul-Rock Fusion, and much more!
Special Pricing! Until July 31, 2024, all the XPro Styles PAKs 1 - 9 are on sale for only $29 ea (Reg. $49 ea), or get them all in the XPro Styles PAK Bundle for only $149 (reg. $299)! Order now!
Learn more and listen to demos of XPro Styles PAKs.
Video: XPro Styles PAK 9 Overview & Styles Demos: Watch now!
XPro Styles PAKs require Band-in-a-Box® 2025 or higher and are compatible with ANY package, including the Pro, MegaPAK, UltraPAK, UltraPAK+, and Audiophile Edition.
Video: Band-in-a-Box® 2025 for Mac®: VST3 Plugin Support
Band-in-a-Box® 2025 for Mac® now includes support for VST3 plugins, alongside VST and AU. Use them with MIDI or audio tracks for even more creative possibilities in your music production.
Band-in-a-Box® 2025 for Macs®: VST3 Plugin Support
Video: Band-in-a-Box® 2025 for Mac®: Using VST3 Plugins
Join the conversation on our forum.
|
|
|
|
|
|
|
|
|
|
|
|
Forums58
Topics84,394
Posts778,637
Members39,646
| |
Most Online25,754
Jan 24th, 2025
|
|
|
|
|
|
|
|
|
Dansk
Deutsch - Windows
Español
Français - Windows
Italiano - Windows
Nederlands
Polski
Português
Svenskt
русский
Japanese
Simplified Chinese
Traditional Chinese
Korean