Re: Opening other applications from within Revolution

2006-02-08 Thread Alex Shaw

hi

Had the same problem in the past..

Found the best solution (so far) is to use an external command launcher, 
at the mo i use..


on Windows: runfile.exe
http://www.winsite.com/bin/Info?50001891

on OS X: launch
http://web.sabi.net/nriley/software/

.. and use rev's shell command to launch.

regards
alex

Recently, [EMAIL PROTECTED] wrote:

>> I'm not interested in importing data from the Excel sheet into Rev, just
>> opening an existing Excel application from a command in Rev.   I 
still can't
>> seem to do this.   I've put the Excel file (and also the Excel 
application)

>> into the same folder as the Revolution stack and just issued the command
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: Opening other applications from within Revolution

2006-02-08 Thread Scott Rossi
Recently, [EMAIL PROTECTED] wrote:

> I'm not interested in importing data from the Excel sheet into Rev, just
> opening an existing Excel application from a command in Rev.   I still can't
> seem to do this.   I've put the Excel file (and also the Excel application)
> into the same folder as the Revolution stack and just issued the command
> (let's 
> say the Excel file is titled "Sample.xls"):
> 
> launch "Sample.xls" with "Microsoft Excel"
> or
> launch "Sample.xls" with "Excel"
> but nothing happens


It sounds like you're missing the path to Excel.  Try using the full path to
the app in your launch script.

Regards,

Scott Rossi
Creative Director
Tactile Media, Multimedia & Design
-
E: [EMAIL PROTECTED]
W: http://www.tactilemedia.com

___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Opening other applications from within Revolution

2006-02-08 Thread Stgoldberg
Hi Phil,
No, I'm not interested in importing data from the Excel sheet into Rev, just 
opening an existing Excel application from a command in Rev.   I still can't 
seem to do this.   I've put the Excel file (and also the Excel application) 
into the same folder as the Revolution stack and just issued the command (let's 
say the Excel file is titled "Sample.xls"):

launch "Sample.xls" with "Microsoft Excel"
or
launch "Sample.xls" with "Excel"
but nothing happens

Am I using the wrong syntax, or can one only do this from a standalone Rev 
program?   Thanks.
Steve Goldberg

In a message dated 2/8/06 4:33:28 PM, [EMAIL PROTECTED] 
writes:

After reading Mathewson's post and re-reading yours, Steve, I'm guessing
I mis-answered earlier. You would rather get spreadsheet data out of the
spreadsheet and into Rev, right?
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: Opening other applications from within Revolution

2006-02-08 Thread Jim Ault
On 2/8/06 6:24 AM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> 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


___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: Opening other applications from within Revolution

2006-02-08 Thread Phil Davis
After reading Mathewson's post and re-reading yours, Steve, I'm guessing 
I mis-answered earlier. You would rather get spreadsheet data out of the 
spreadsheet and into Rev, right?


It might be possible to write a vbscript that reaches out and asks Excel 
to give it the tab-delimited text of some selected spreadsheet, but I 
haven't tried it. Ken Ray may have a related tip on his web site. 
(Looking...) I see this one there, related but not spot-on:


  http://www.sonsothunder.com/devres/revolution/tips/iac001.htm

All the best -
Phil


[EMAIL PROTECTED] 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.   Thanks.

Steve Goldberg


___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Opening other applications from within Revolution

2006-02-08 Thread Mathewson
Maybe I'm a bit stupid - but this seems rather redundant;
unless one is building a sort of TaskBar with RR.

What is much more interesting, to my mind, is the ability
of RR stacks to import data from documents/files generated
by other applications (cf RR's database capabilities),
process it, and, if necessary, export the processed data in
a form that the parent program of the originating
document/file can read.  This is a way that the "small man"
can access data in files generated by hugely expensive
proprietary applications for the price of, for example,
DreamCard.

Now, far be it for me to 'rubbish' Microsoft products
(cough, cough), but it is a well-known fact that Microsoft
and its software products dominate the computer world -
with the extremely undesirable result that a very large
part of the world depends on pirate software to get its
business done. As a person who is not over-enamoured of
either Microsoft products or pirate software, and
understands that full-blown Open-Source equivalents (cf.
Open Office) take years of effort, it seems to me that
there might be quite a niche for RR-developed programs to
access (um; MS Access is one of the cases in point)
proprietary formats quickly and inexpensively.

During my Masters degree course at the University of
Abertay (breath in a moment here) the programming
instructor taught us extremely simple stuff with Visual
Basic (why Abertay claimed that those who finished the MSc
in Computers and IT would be at an equivalent level to
those who had completed a 4-year undergraduate course I
will never know) - one of the programming exercises was to
build a front-end to retrieve information from a MS Access
file. The main thing I learnt during that course was that
Visual Basic was incredibly clunky compared with RR - and
that almost everything that VB could do, RR could do at
least as well if not slighty better. It was never explained
to us how learning to write a program that displayed seven
varieties of cars in a showroom would equip us for the real
world of computer programming (especially as I remember
doing real number-crunching stuff with Fortran in 1976 at a
school); in fact nothing was either justified or
rationalised - so I drew my own conclusion, which was that
the underpinnings of MS Office and so on being VB (or VBA)
should mean that it would be relatively easy to write RR
equivalents of all those VB exercises that opened Excel
docs, etc without all the rather odd, old-fashioned legacy
stuff that seemed to be built into VB + (of course) the
platform dependency which MetaCard managed to get beyond
when it took on the Hypercard platform dependency problem.

Having written this I will now try to find a spot of time
to run up a sweet little number to extract data from an
Excel file - and, as usual, I expect I'm a bit late in the
race and some fiendishly clever RR/MC maven has managed
this already!

sincerely, Richmond Mathewson

PS. Just poked my nose into a Microsoft website:

http://www.microsoft.com/presspass/press/2006/jan06/01-10Macworld2006PR.mspx

where I read something about Open XML - obviously nobody is
going to have to work too hard if data is really stored in
open XML (rather than xml + some funny encryption).
__
See Mathewson's software at:

http://members.maclaunch.com/richmond/default.html
___
---
The Think Different Store
http://www.thinkdifferentstore.com/
For All Your Mac Gear
---
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Re: Opening other applications from within Revolution

2006-02-08 Thread Phil Davis

Hi Steve!

You can use the "launch" command for this. Here's a basic script I just 
put together and used to open a PDF file with Acrobat Reader:


on mouseUp
  answer file "file?"
  if it = empty then exit mouseUp
  put it into tFile

  answer file "app?"
  if it = empty then exit mouseUp
  put it into tApp

  launch tFile with tApp
end mouseUp

Phil Davis



[EMAIL PROTECTED] 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.   Thanks.

Steve Goldberg
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution



___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Opening other applications from within Revolution

2006-02-08 Thread Stgoldberg
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.   Thanks.
Steve Goldberg
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution