Page 1 of 1
Working with excel and replacing the VBE with RunRev
Posted: Mon Jul 30, 2007 10:44 am
by gdonin
Is it possible to use runrev to replace the VBA scripting in Excel and still keep the Spreadsheet as is?
Thanks in advance.
Regards
Gary
Posted: Mon Jul 30, 2007 12:04 pm
by Mark
Hi Gary,
Everything is possible, if you are willing to invest sufficient time and/or money ;-)
Best,
Mark
Posted: Wed Aug 01, 2007 6:57 pm
by Janschenkel
Hi Gary,
On Mac, Revolution can interact with Excel by means of AppleScript, and update the contents of cells.
On Windows, you can achieve the same effect by using the Windows Scripting shell, but then you're actually back to using VBA.
You can't do it directly from Revolution, though - you always have to pass through another scripting language to get at Excel.
For more information on integrating a Revolution-based application with Microsoft Office, take a look at Ken Ray's excellent tips and tricks:
http://www.sonsothunder.com/devres/revo ... lution.htm
In particular, you'd want this item:
http://www.sonsothunder.com/devres/revo ... iac001.htm
Hope this helped,
Jan Schenkel.
Posted: Wed Aug 01, 2007 7:03 pm
by Mark
Hi Jan,
I think that Gary wants to programme Excel with Transcript rather than using VB from within Revolution.
Best,
Mark