Opening other applications from within Revolution

[Jim Ault]

On 2/8/06 6:24 AM, "Stgoldberg at aol.com" <Stgoldberg at aol.com> wrote:

> I have an Excel file on my hard drive that I would like to access from within
> revolution (just like I can access the Internet through RevGoUrl).   What
> command can issue to open and see the file?   I am having some trouble trying
> to 
> do this through the "open" or "open file" commands.

I assume you are referring to a spreadsheet (.xls, since there are several
types of Excel files).  This is a very complex format that would really
require the Excel app to work with.  You do have options.

Save the data as a tab delimited text file and read it directly in Rev.
Open the workbook xls file in Excel and communicate with Excel to
send/retrieve cell values/update formulas, etc.

The communicate with Excel is done via VB on Windows and Applescript on Mac.

Ken has a great starting point on his site and Microsoft has very good PDF
documentation of the object model and use on their web site.

Let me know if you want a few primitive examples of Mac stuff, since I use
it for one of my projects.

Jim Ault
Las Vegas