Extracting From Excel and Access

[Mark Powell]

I'd be very interested in looking at it.  My problem is that there is
mission-critical data in our organizaiton that is residing in several
locations (John's Excel file, Mary's Access db, Fred's web page, etc.), all
owned and maintained by separate individuals with varying degrees of
housekeeping acumen.  I need to point to these sources and perform some
critical filtering, stitching, and formatting, with the final product being
a sortable HTML report (for users) and an error/issue report (for
management).

So, I don't have control over what file types are being used.  Currently, I
have to go into manually and save these things as tab-delimited text, and
then first apply a very robust housekeeping check before commencing on
anything.  So, yeah, it would be very handy to be able to address the data
directly without this manual intervention.

Let me know what your timeline is and thanks for the info!

Mark

-----Original Message-----
From: Joeri Paeleman [mailto:paeleman at hotmail.com]
Sent: Thursday, July 24, 2003 1:45 PM
To: use-revolution at lists.runrev.com
Subject: Re: Extracting From Excel and Access



If you're not in a hurry, I'm writing a little external which will allow you

to do just that.

The external will make it possible to execute OLE commands directly from 
Revolution. This means than a lot of what's possible in Visual Basic (at 
least regarding Interapplication Communication) will be available in 
Transcript, including running VBscripts in a way similar to AppleScript.

Actually I've been using the external myself for some time now, but I still 
need to find some spare time somewhere to prep it for distribution (other 
people usually manage to find bugs in my code that I would never encounter 
myself).


Joeri Paeleman

_________________________________________________________________


_______________________________________________
use-revolution mailing list
use-revolution at lists.runrev.com
http://lists.runrev.com/mailman/listinfo/use-revolution