Running a VBA macro outside of excel... possible???

[LSIGuy]

I wrote a host pinging program for my job. It works great a continuously (Thanks to many of you guys out there). I had just one more question for this specific project. Can I compile this program into an exe or something so I don't have to have excel and VBEditor to open it? The idea is to have it running on all the desk tops in my area, but many people do not like the idea of having excel upon constantly. Any help would be greatly appreciated!

Thanks,
LSIGuy

 

[SkipVought]

Hi,
Jexport the module and import it into VB, compile and run. Skip,
SkipAndMary1017@mindspring.com

 

[LSIGuy]

Will this work if I have a user form as well?

 

[SkipVought]

If you have any Excel objects, then you need to reference Excel ver in Tools/References in VB. But if VB will compile as is, it should work. Why not try it? Skip,
SkipAndMary1017@mindspring.com