MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

VBA(Excel) programs as .EXE?

  Asked By: Jesse    Date: Feb 27    Category: MS Office    Views: 14138

Is it possible to save applications developed in VBA (Excel) as .EXE



7 Answers Found

Answer #1    Answered By: Vicki Fields     Answered On: Feb 27

VBA MEANS Visual Basic for Applications, which means it NEEDS a host
app to run. So you can't create a self-running EXE as you can with VB. With
VB, you compile the code to create the EXE. With VBA...the code is only
compiled when it is first run in that instance of the host app.

Answer #2    Answered By: Isra Demir     Answered On: Feb 27

In that case, is there a way to convert the VBA code to VB and use as
an exe? The reason I want to do this is to not give away the source
code in the VBA macros. I am told the password feature of VBA macros
isn't very secure. Could you point me to resources on securing
application/code in VBA for Excel?

Answer #3    Answered By: Abrianna Rossi     Answered On: Feb 27

However, there's no easy tool that I know of??? Plus, if you've written code
say for Excel, if you're running it outside of Excel with VB, you'd have to
rewrite much of it since the original code would work directly with the
Excel Object Model...which wouldn't be active in an EXE. So you'd have to
rewrite much of it. It would probably be a hassle...if it even worked in the
end, anyway.

Sure, you CAN buy hacking programs  that go through all possible combinations
in order to break into the code, but the harder you make the pass, the
longer it will take...several days or more depending on the software you
might buy. And remember, that users would have to give their credit card
number to hackers to get the software...not something I'd bother to do for

And there's probably a good chance that anything you've written is somewhere
on the web for free in support groups...that others could work out anyway
with time.

The bottom line is that if you make the pass a complex one, the chance that
anyone would bother to get the software and take the time to bust into your
code seem pretty slim...a lot less than the hassle you'd take to try to
create an EXE. Use a pass with a lot of mixed letters and numbers in both
upper/lowercase and make it long. Just don't forget your pass or you'll be
fighting to get into it.

Answer #4    Answered By: Damon Jones     Answered On: Feb 27

I have no idea what you've written and sorry,
don't have time to examine it. But YOU know what you've written, so it's
time to get a lesson in web searching.

Think about key words that focus on what you are trying to do. Then start
searching. Go to groups.goggle.com and enter a few key words or terms and
check out the conversational threads in various support groups on the web.
You can narrow down the search by adding a site. Such as if you wanted to
search the Microsoft newsgroups, enter "keywords" (that being the words
you're searching on) and then site:microsoft.com.

You can get more help searching by checking out these two TechTrax articles:

How To Get Help

Refining Your Internet Searching

Answer #5    Answered By: Varun Mehta     Answered On: Feb 27

One more quick question:

A strange problem: for some reason when I run one particular excel  VBA
application it runs, but when I want to view the code, the VBA editor
wouldn't open at all (the CPU usage goes to 100% and stays that way,
and after a while, the message 'not responding' appears). The same
Excel file cannot be saved as any other file either.

It was working fine when I saved it last (there were a couple of power
failures after that). My other excel-VBA applications  do open up for

Is there a way I can recover the macro code from this file? I searched
for answers, some suggested correcting the registry (but since the
remaining workbooks allow opening of VBA, I am not sure I should
attempt that).

Answer #6    Answered By: Vidhya Iyer     Answered On: Feb 27

I wasn't expecting anyone to look into my code
or search on my behalf; apologies if I conveyed that impression.

Answer #7    Answered By: Alvin Nguyen     Answered On: Feb 27

I have a few links, that I consult when I need help:

(not in priority).

But there are several others - a good google search is valuable.

Didn't find what you were looking for? Find more on VBA(Excel) programs as .EXE? Or get search suggestion and latest updates.