executable file

chouston · Apr 30th, 2002, 11:21 AM

is there any way to create an executable file using VB? If not, do any of you have a recommendation on how I could do this?

I'm trying to create an application that will offer several automated tasks for our clients (who have trouble turning their computers on). Most of these tasks use excel, but one uses Outlook, and the other uses their accounting software. I'd like to create an icon on their desktop that they can just click and follow instructions.

chouston · Apr 30th, 2002, 11:26 AM

I just re-read my post and realized part of it doesn't make sense, when I said that our clients have trouble turning their computers on, I was trying to say that they are very inexperienced with computers. Oops.

Tom Schreiner · Apr 30th, 2002, 12:00 PM

Hee Hee...
SOme of the people I work with would have trouble turning thier computers on...
You said VB.
Different from VBA.
VBA runs kinda like a dll in the host's same process.
If you have VB(Stand alone) then yes, you can control Excel via OleAuto.
If you are talking about compiling VBA into an executable, then no, you cannot.
Please clarify..
Tom

chouston · Apr 30th, 2002, 12:09 PM

hmm, I always wondered why everyone used VBA instead of VB. I'm using VBA, but am willing to purchase wahtever software would be best. A friend mentioned Director and since he no longer uses it, is willing to give to me for free, could this be the answer to my problems?

Tom Schreiner · Apr 30th, 2002, 12:45 PM

VB is more powerful than VBA.
I have no clue what Director is.
You can automate other applications
via VBA just as you can in VB, but not as a stand alone executable.
Tom

Rocky E · Apr 30th, 2002, 01:30 PM

Hi chouston,
I agree with Tom! Visual Basic or VB is available. Current version is 6.0. The code you would compile and distribute would be yours and yours alone. The code does require a runtime, but it is a FREE download. Checkout karenware.com for some great examples of VB, including the source.

Like Tom "Director" doesn't ring a bell, but I would bet they would not take kindly to you redistributing thier software.

VBA is for Visual Basic for Applications. It is built in to the MS Office products like "Excel".

Apr 30th, 2002, 01:30 PM	#6
Rocky E Board Regular Join Date: Feb 2002 Location: North Alabama, USA Posts: 105	Hi chouston, I agree with Tom! Visual Basic or VB is available. Current version is 6.0. The code you would compile and distribute would be yours and yours alone. The code does require a runtime, but it is a FREE download. Checkout karenware.com for some great examples of VB, including the source. Like Tom "Director" doesn't ring a bell, but I would bet they would not take kindly to you redistributing thier software. VBA is for Visual Basic for Applications. It is built in to the MS Office products like "Excel". __________________ Hope this helps! Rocky <h6>"Be not the first by whom the New are try'd, Nor yet the last to lay the Old aside." Alexander Pope (1688-1744).</h6>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 30th, 2002, 11:21 AM	#1
chouston Board Regular Join Date: Apr 2002 Location: Arizona Posts: 68	is there any way to create an executable file using VB? If not, do any of you have a recommendation on how I could do this? I'm trying to create an application that will offer several automated tasks for our clients (who have trouble turning their computers on). Most of these tasks use excel, but one uses Outlook, and the other uses their accounting software. I'd like to create an icon on their desktop that they can just click and follow instructions.

Apr 30th, 2002, 11:26 AM	#2
chouston Board Regular Join Date: Apr 2002 Location: Arizona Posts: 68	I just re-read my post and realized part of it doesn't make sense, when I said that our clients have trouble turning their computers on, I was trying to say that they are very inexperienced with computers. Oops.

Apr 30th, 2002, 12:00 PM	#3
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hee Hee... SOme of the people I work with would have trouble turning thier computers on... You said VB. Different from VBA. VBA runs kinda like a dll in the host's same process. If you have VB(Stand alone) then yes, you can control Excel via OleAuto. If you are talking about compiling VBA into an executable, then no, you cannot. Please clarify.. Tom

Apr 30th, 2002, 12:09 PM	#4
chouston Board Regular Join Date: Apr 2002 Location: Arizona Posts: 68	hmm, I always wondered why everyone used VBA instead of VB. I'm using VBA, but am willing to purchase wahtever software would be best. A friend mentioned Director and since he no longer uses it, is willing to give to me for free, could this be the answer to my problems?

Apr 30th, 2002, 12:45 PM	#5
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	VB is more powerful than VBA. I have no clue what Director is. You can automate other applications via VBA just as you can in VB, but not as a stand alone executable. Tom