Thread: VBA platforms?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
John Coleman John Coleman is offline
external usenet poster
 
Posts: 274
Default VBA platforms?


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