Sup.
I checked it out and it turns out the standard EXE is a modified version of a full BW 1.07 StarCraft.exe that uses Vision3.mpq as a replacement for patch_rt.mpq, rather than being a separate mod program that launches the standard StarCraft.exe and injects code into it at runtime like most campaign mods had. Version 1.07 of course was before the official no-CD patch from Blizzard so that could be part of the problem (no idea why it wasn't working even with your disc in the drive though? Copy protection incompatibility with modern hardware? You were using a legit CD weren't you?
)
So I ran SFNoCD on it and it seemed to work properly; save for a few empty/broken dialog boxes since 1.07 was before replay support was added (which is obviously no biggie). Chuck these 3 files in your SC folder and run the EXE as normal:
http://starcraft.rwslol.com/junk/vision3.zip Let me know if you still have problems though :\
I could probably have a look at things and try and copy the mod data over to the latest EXE, then if RCX would be interested in writing epilogue/splashscreen text I could then also add extra hacks to include the map files in the EXE and have all 16 of them launchable in place of the 8 in the default BW Protoss campaign (with UI editing to remove the Terran & Zerg campaigns from the menu and have the Protoss one renamed with a new image/animation), I only learnt how to do that a few months ago and since I gave up on that cyberpunk campaign I was planning I could do it for some old CC classics
): 
