Opening other applications from within Revolution
JimAultWins at yahoo.com
Wed Feb 8 14:28:18 EST 2006
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
> 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.
More information about the Use-livecode