vba running help...

What if I want to run a vba code file by itself in windows? How do I do it?

Thanks,

Devin

 

If I understand your question accurately, you can't. You'd need to use full
VB6 to create an executable file [exe]. VBA requires the host program.

-- Mike
___________________________
Mike Tuersley
CADalyst's CAD Clinic
Rand IMAGINiT Technologies
___________________________
the trick is to realize that there is no spoon...

 

Write it in VB.

--
Matt W

The difference between genius and stupidity is that genius has its limits.
| What if I want to run a vba code file by itself in windows? How do I do
it?
|
| Thanks,
|
| Devin
|
|

 

VBA requires a host process to run in. To run your code "by itself", in its
own process, you would have to use VB to compile it to an exe.

 

use vb6, compile to .exe
vba will only run in it's parent application
Mark

 

Thanks,

is there a way to get excel to automatically run it without opening excel?

 

How bout if I send it to one of you guys and you compile it instead of me
buying visual basic?

Thanks,

Devin

 

How about no.

What *exactly* are you trying to do?? You've mentioned AutoCAD, then you
through Excel into the mix.
You don't want AutoCAD open and now it sounds like you don't want Excel open
but you still want to run some sort of VBA app. Something's gotta give.

It's like asking someone to drive their car without gas and a key.

--
Matt W

The difference between genius and stupidity is that genius has its limits.

| How bout if I send it to one of you guys and you compile it instead of me
| buying visual basic?
|
| Thanks,
|
| Devin
|
|

 

Get it for free.
http://lab.msdn.microsoft.com/express/vbasic/default.aspx
I am currently using it until we get Visual Studio.

Regards - Nathan