Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel platforms | Excel Discussion (Misc queries) | |||
Need a count of #of times a result occurred on multiple platforms | Excel Worksheet Functions | |||
References changing between different platforms - DLL hell returns! | Excel Programming |