i love this thing! unfortunately, i can't find anywhere in the code to change key mappings or to use another set of drum sounds. I hit alt-F11 and the only real code I see doesn't have anything about keys or drum sounds.

of course, I'm a VB noob, so I probably am just missing something. help?

btw I have it working with the korg drum sounds and the default key mapping

when trying to open, i get an error messaage: Automation Error.

I put the Bass.dll in the windows directory, when opened the Excel file it says it can find the BASS.dll file. any ideas?

James: You need to right click the Drumpad Form on the left (it's the only one there) and pick View Code to get to the keys and everything.

Powertothepeople: No idea what to do about the Automation error. I'll look into it.

Julius: You might try putting it in the system32 folder inside windows instead, but that's all I can figure. I know that it doesn't have to be registered, and I'm not that informed about VBA .dll access otherwise. Sorry!

i tried d/ling http://www.milezero.org/drumpad.zip
but its telling me there nothing in the zip can u pls update/fix
thank you

I tried it again just now, and everything seemed to be in order. What are you using to open the file?

i downloaded it and put the dll file in my winnt folder. i clicked on the sheet and i comes up the drums. but when i keys on my keyboard, theres nothin

push key*

Do you have multiple sound sources running on your computer? DrumPad basically uses the BASS defaults, which try to auto-sense where output should go. I think you can force them by setting the parameter to 1 where I call BASS_Init().

And you know, always check your system volume. Because that gets me a lot.

thomas thanks i forgot to d.l winzip after i reformatted xp i was using open comppressed file or something like that =x

prety cool, everything working here. the default sounds are a little cheap, but maybe get some others sometime.

Thx, but dont know how toget parameters lol

set*

thanks for the help Thomas! I have it working, with two kick sounds, two snare sounds, crash and ride cymbals, and three toms, using drum sounds i found online.

Dave, setting parameters is easy once you find the file to set them in (hit Alt-F11 and then see the third comment above).

Theres no sound :(

Note: some people who haven't gotten sound from this have forgotten to download the samples. It doesn't come with the .wav files, but there's a link in the post.

Other than that, I'll try to help, but this isn't exactly highly reliable code here.

Here is a free drum machine for you. Not quite as cool as yours but they also have a dos version. http://www.bluemoon.ee/history/scwin/index.html

C'mon folks... so a handful of you are having technical problems. Meh. What you're not realizing is that we're talking about a DRUM MACHINE IN EXCEL. It's a pretty nifty little hack. The least you can do is give the man some props and thank him for working to push the boundaries of fun cool things to do in Excel.

Thomas, from one Excel geek to another - I salute you. :)

you know, it wouldn't be too hard to use spreadsheats to record performances or build up a library of riffs.

Herichon: Thanks!

Monkeyboy: If you check a later link in this same category, you'll see that a reader already turned it into a programmable drum machine. So yeah, being able to record/play back performances shouldn't be that hard. And perhaps eventually I'll get around to doing it. I hope.

Very cool program. Great work!

Neat example of how cool some things in excel can be.

Can we use Excel to do a sequence using those Korg samples?

This is a fun toy :)

Click here for the sequencer version.

brilliant !!! what a hoot !! Now, if only this was a standard part of office,,,

PS for those having issues with getting it to work; as always, the answer shall be found in the mustical words RTFM

1) make sure you download the Korg DDM-110 samples
2) make sure you have a copy of bass.dll in your WINDOWS directory

great hack thomas! Im horrible with excel so how you have done this is beyond me, but is there any way that you could add on to this program so you would be able to punch in a drum beat and have it play back over and over just like a real drum machine?

Not as a recording, no, not yet. It's in the plans for future versions. But you can sequence it, using the link a couple comments up.