VBA platforms?
 

Does VBA have to run on a microsoft platform like Excel?
Are there other options?

What if i want to run my VBA program and have it not appear as an excel
project?

--
dr chuck

VBA platforms?
 

I am afraid as far as VBA is concerned, it has to run within the framework of
one of the MS applications - Excel, Access, Word and Visio. (I might be
missing one or two more!)

It can do not MS application specific processing - for example processing
data in text or binary files but you still need to open the MS application
where the VBA code resides and run the VBA code from there.

The other option is to use VBScript - which is not tied to MS Office
applictions and can be run outside of those applications. Or you can use
JavaScript.

Alok
"dr chuck" wrote:

Does VBA have to run on a microsoft platform like Excel?
Are there other options?

What if i want to run my VBA program and have it not appear as an excel
project?

--
dr chuck

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

VBA platforms?
 

John,
thanks for your thoughts ...
Is it also possible to change the icon of your file to a non excel icon?

--
dr chuck


"John Coleman" wrote:


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

VBA platforms?
 

dr chuck wrote:
John,
thanks for your thoughts ...
Is it also possible to change the icon of your file to a non excel icon?

(snip)

I'm sure it's possible for an uber-programmer who understands the
Windows registry and API to change it into whatever they want. That
isn't me. What you *could* do is write a short VBS script to launch the
excel application. Something like:
__________________________________________________ ___________

'Launcher.vbs

Option Explicit

Dim xlApp, xlWB, myPath

Set xlApp = WScript.CreateObject("Excel.Application")
myPath = "C:\Documents and Settings\jcoleman\My Documents\"
Set xlWB = xlApp.Workbooks.Open(myPath & "Dijkstra.xls")
xlApp.Visible = True
xlApp.UserControl = True
Set xlWB = Nothing
Set xlApp = Nothing

__________________________________________________ ______________

Write it in Notepad and save it as Launcher.vbs to say your desktop -
then you can click a VBS icon rather than an Excel icon. I don't know
what you would really gain from that.

Hope that helps.

-John Coleman

VBA platforms?
 

You can also hide the host application if that is the concern.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Alok" wrote in message
...
I am afraid as far as VBA is concerned, it has to run within the framework
of
one of the MS applications - Excel, Access, Word and Visio. (I might be
missing one or two more!)

It can do not MS application specific processing - for example processing
data in text or binary files but you still need to open the MS application
where the VBA code resides and run the VBA code from there.

The other option is to use VBScript - which is not tied to MS Office
applictions and can be run outside of those applications. Or you can use
JavaScript.

Alok
"dr chuck" wrote:

Does VBA have to run on a microsoft platform like Excel?
Are there other options?

What if i want to run my VBA program and have it not appear as an excel
project?

--
dr chuck