On Thursday, July 24, 2003, at 10:32 AM, Mark Powell wrote:
Can anyone give me a pointer as to how to perform the following 2 pseudo-procedures
-1- Open Excel file 'foo.xls' Copy all the fields of sheet "blah" as text put it into a var
-2- Open Microsoft Access file 'foo.mdb' Copy Table 'blah' as text put it into a var
I am on Windows 2000 and I am not currently interested in querying the
contents of either. I just want to extract and ruminate within Revolution.
There is no way to script Windows apps from within Runrev. So you would have to manually perform steps a) and b) of each of your list.
c) "put it into var"- Excel puts tab delimited data onto the pasteboard and probably other types. Most well developed apps put several data types on the pasteboard. Using RR 2.0's new pasteboard features, you can inspect the keys of the pasteboard and pick what data type you want to put into your var.
Alex Rice, Software Developer Architectural Research Consultants, Inc. http://ARCplanning.com
_______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
