So, VB6 doesn't have a command-line compiler.

I want to compile VB6 projects automatically. I'm open to any ideas that anyone has ever heard rumours of. I'm not going to rule out any approach yet: simulating mouse clicks on the IDE, running a debugger against VB6.exe from another process, anything goes.

Suggestions please!

Switch to VB.NET?

I agree. I easily made the transition in a couple of days of fiddling around with VS2005.

No, not an option I'm afraid. This is a legacy app that will be replaced long before it is ported, and it won't be replaced for the foreseeable future. I'm hoping to set up a build server that can compile it, so we can start doing continuous integration to make maintaining it easier until that time.

I'm at school without my vb6 so this could be very wrong.

There's a reference you can include for Excel that you can use to write vb programs that can perform basically any function in Excel. Maybe look around in the reference list for something like that for vb6?

Oh, I know close to nothing about windows programming, but are you talking about OLE automation? I read a VB6 book years ago that had a chapter on it.