opening and amending an excel spreadsheet from filePro

[John Esak]

Yes, you are right. The method I suggested would lose your original
formulas, macros... Stuff.  Good thought. Didn't know they were importatn...
But I should have.

As for implementing a macro. In Microsoft word you just do:

Msword.exe -m macroname

(or whatever the executable name for Word is...)

At least this used to work. I haven't tried it recently, and I'm just
guessing that it would work on Excel.  You would think they keep all the
Office programs looking and feeling the same... With the same basic
libraries when they compile, so that should be something that works in all
the Office stuff... However, you need to try it, I wouldn't count on
anything these days. :-)  :-(

John
 

> -----Original Message-----
> From: Dennis Malen [mailto:dmalen at malen.com] 
> Sent: Thursday, April 22, 2010 4:49 PM
> To: john at valar.com; filepro-list at lists.celestial.com
> Cc: filepro-list at lists.celestial.com
> Subject: Re: opening and amending an excel spreadsheet from filePro
> 
> John,
> 
> That is basically what we are doing except for the manual 
> process of opening 
> up the excel spreadsheet and savings as a tab delimited file, 
> then importing 
> into filePro. Exporting back out is not a problem but I 
> wanted to try to 
> keep the original spreadsheet intact as the third party may 
> or may not have 
> some unique formulas in the file. Those formulas would be 
> lost once we 
> export back out to .csv with an .xls extension. Furthermore I 
> am not aware 
> of how to implement the macros remotely.
> 
> Dennis Malen
> 516.479.5912
> ----- Original Message ----- 
> From: "John Esak" <john at valar.com>
> To: "'Dennis Malen'" <dmalen at malen.com>; 
> <filepro-list at lists.celestial.com>
> Cc: <filepro-list at lists.celestial.com>
> Sent: Thursday, April 22, 2010 3:09 PM
> Subject: RE: opening and amending an excel spreadsheet from filePro
> 
> 
> >I agree with Ken's suggestion.  But, just curious... What 
> you are doing now
> > sounds like enough. What's wrong with it?  I am not sure, 
> but I think you
> > can even name the .csv back to .xls... And it gets read in. 
>  Maybe not, 
> > but
> > the .csv could automatically be read into Excel and then 
> written out as a
> > .xls and you could send that one?  No?  It's a long way 
> around the horn, 
> > but
> > it would work wouldn't it? That is if you dumping their .xls into a 
> > .csv....
> > Reading it in, processing it, then writing back out a new 
> .csv. The last
> > step would be to read in that .csv into Excel and write it 
> out in its 
> > native
> > format?  Macros could do all this pretty easily, right?  I 
> know we did
> > miracles with word documents and the -m flag along with 
> some carefully
> > recorded macros.  Assuming Excel's macro recorder is the 
> same as the one 
> > in
> > Word, which it must be.
> >
> > John
> >
> >> -----Original Message-----
> >> From: filepro-list-bounces+john=valar.com at lists.celestial.com
> >> [mailto:filepro-list-bounces+john=valar.com at lists.celestial.co
> > m] On Behalf Of Dennis Malen
> >> Sent: Thursday, April 22, 2010 10:52 AM
> >> To: filepro-list at lists.celestial.com
> >> Subject: opening and amending an excel spreadsheet from filePro
> >>
> >> We have the need to modify an excel spreadsheet received by
> >> third parties.
> >> Within the spreadsheet received from the third party is
> >> enough information
> >> to search for a filePro record. What we would like to do 
> is to create
> >> processing that seamlessly opens the excel spreadsheet, looks
> >> up the record
> >> in filePro and then places the appropriate information in a
> >> specific column
> >> and line and closes the file ready to return to the third party.
> >>
> >> What we do now is create tab delimited file from the excel
> >> spreadsheet,
> >> import that into a filepro file, do the lookups and then export the
> >> information in a .csv file and return to the third party.
> >>
> >> Any thoughts or help would be appreciated.
> >>
> >> Dennis Malen
> >> 516.479.5912
> >>
> >> _______________________________________________
> >> Filepro-list mailing list
> >> Filepro-list at lists.celestial.com
> >> http://mailman.celestial.com/mailman/listinfo/filepro-list
> >>
> > 
>