Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Can VBA macros be compiled?

0 views
Skip to first unread message

Paladin046

unread,
Jan 3, 2010, 6:32:56 PM1/3/10
to
Can Excel and/or word VBA macros be compiles to exe files as you can
in true visual basic?

Mike Middleton

unread,
Jan 3, 2010, 6:54:04 PM1/3/10
to
Paladin046 -

No.

- Mike
http://www.MikeMiddleton.com

"Paladin046" <gw.bo...@gmail.com> wrote in message
news:f7b8bb1f-3738-4864...@v25g2000yqk.googlegroups.com...

Harald Staff

unread,
Jan 4, 2010, 11:52:57 AM1/4/10
to
Hi

VBA is VB6 using MS Office objects. If you can get hold on a copy of Visual
Studio 6 (it's pretty old) and modify your copy-pasted code so it doesn't
rely on the Office objects (or properly address Office from a standalone
app), then you can create exe files with it.

HTH. Best wishes Harald


"Paladin046" <gw.bo...@gmail.com> wrote in message
news:f7b8bb1f-3738-4864...@v25g2000yqk.googlegroups.com...

0 new messages