dr chuck wrote:
Does VBA have to run on a microsoft platform like Excel?
Yes - it must run in a host application.
Are there other options?
Well, if you want to escape Microsoft completely you would have to do
something like use Python. If it is just Office you want to escape,
consider using VBScript.
http://msdn.microsoft.com/library/de...scriptinga.asp
What if i want to run my VBA program and have it not appear as an excel
project?
Two ways:
1) Make a form visible but Excel invisible. This risks leaving an
invisible instance of Excel running.
2) Hide toolbars, turn off gridlines, sheet tabs, scroll bars, row and
column headers. Go Full Screen. This can all be done in code (turn on
your macro recorder while playing around with tools - options to see
how to do so) and put in a workbook open event. You can hide the fact
that it is Excel almost completely.
Hope that helps
-John Coleman