Visual Basic HELP!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[George VII]

Alright, I just started using the visual basic editor in Word 97, and I have been fooling around with a trying to make a program, but I am having a few problems. First, in my program, I cannot figure out how to make a command button, that when you click on it, it opens another program. And second, I can't figure out how to make it into a .EXE when I am all finished with it. Can anyone help me please????????!!!!!!!!!!!!

[surreal]

Well, Virtual Bovines have just been ruled out.

[thehig]

Well.. you can not compile a visual basic for applications program into an .exe. At least not to my knowledge. The other thing can be done give me a bit to remember how. Sorry not much help I know.

[surreal]

Hey thehig!! Where ya been? Good to see you!


Sorry George VII ... about being way off topic.

[George VII]

*whistles and looks around inicently* what do you mean? What topic?

Yes, that does rule out Virtual Bovines, which is not exactly my specialty!

[vass0922]

thehig is correct, you can't compile a VBA program into an exe it is stored into the document itself
To create an exe you'll have to get the full version of VB6 (or VB.NET if you're really wantin' to push it lol)

For the command button, there should be a "Toolbox" button on the command bar somewhere, that will allow you to add controls like that.

[strangerstill]

To make a command button open another program, you need first to put the command button on the form - I assume you know how to do this!
Then, in its Click event, put this code:

Shell "pathname\exename", vbNormalFocus

[vass0922]

Whoops misread about the command button... sorry
Yup strangerstill's method should work

[George VII]

Thanks! I'll try this. -me