using Excel in RevStudio

[jonesse]

Hi, has anyone ever turned an Excel spredsheet into a compiled program using RevStusdio, please? Thanx

[marielle]

What is the meaning you put into Excel spreadsheet?
1. A complex table object that very much looks like an excel spreadsheet.
2. An xls file containing the excel spreadsheet?

[jonesse]

Marielle

Thank you, I see I cannot even spell the word. I meant using an existing Excel spreadsheet with numbers and formulae and turning that into an executable with Runtime Studio. Is that clearer?

[marielle]

Using an existing Excel spreadsheet with numbers and formulae and turning that into an executable with Runtime Studio.

Yep, possible. Should be manageable for a user with good command of VBA, OS scripting languages, revolution.

From with the revolution environment, click on Documentation, enter applescript as search term. Click on the red Applescript term on the page that appears. This will connect you to a tutorial "Outstide World: Communication with Shell, Processes, Applescript of Externals".

That document explains how to communicate with other applications from within revolution.

That's a first step covered... getting access to the content of your Excel Spreadsheet from within revolution.

After that, you still have to convert your spreadsheet content to revolution. Easy for the data (cut and paste will do... you can do it via script). More difficult for the formula... the excel syntax needs to be translated into a revolution/transcript/xtalk one.

Marielle