excel macro call filePro?
Fairlight
fairlite at fairlite.com
Thu Jul 8 17:22:33 PDT 2004
>From inside the gravity well of a singularity, GCC Consulting shouted:
>
>
> > -----Original Message-----
> > From: filepro-list-bounces at lists.celestial.com
> > [mailto:filepro-list-bounces at lists.celestial.com] On Behalf
> > Of Scott Nelson
> > Sent: Thursday, July 08, 2004 5:33 PM
> > To: FilePro Mailing List
> > Subject: excel macro call filePro?
> >
> > Does anyone have a sample of an excel macro that runs a batch
> > file? I would like to run a filepro process to export data
> > to grab in excel.
> >
> > Or am I dreaming???
>
> Scott,
>
> Are you trying to go out to fp based on data in an Excel element?
>
> Or are you trying to output from fp to be imported into fp?
The way I read it, he has an Excel spreadsheet and wants to fire off a
macro that will launch a batch file (from inside Excel) that runs filePro
(said fP process exporting data to a file), and then import that data file
into Excel after completion of the batch file.
If I'm correct about the scenario he proposes, my wife and I have this
solved with working and tested Excel code. All one needs to do is plug the
relevant import in at the appropriate spot in the macro code. Works like a
gem.
mark->
--
Bring the web-enabling power of OneGate to -your- filePro applications today!
Try the live filePro-based, OneGate-enabled demo at the following URL:
http://www2.onnik.com/~fairlite/flfssindex.html
More information about the Filepro-list
mailing list