Working with excel and replacing the VBE with RunRev

gdonin · Post by **gdonin** » Mon Jul 30, 2007 10:44 am

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

Mark · Post by **Mark** » Mon Jul 30, 2007 12:04 pm

Hi Gary,

Everything is possible, if you are willing to invest sufficient time and/or money ;-)

Best,

Mark

Janschenkel · Post by **Janschenkel** » Wed Aug 01, 2007 6:57 pm

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.

Mark · Post by **Mark** » Wed Aug 01, 2007 7:03 pm

Hi Jan,

I think that Gary wants to programme Excel with Transcript rather than using VB from within Revolution.

Best,

Mark