<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><DIV>[ sorry top posted ]</DIV>
<DIV> </DIV>
<DIV>Harold,</DIV>
<DIV> </DIV>
<DIV>For years I have allowed users to access Word, Excel, Notepad(++), Internet Explorer, etc from with in fp. Note I do this from the review mode not while in input. (Just never tried it).</DIV>
<DIV> </DIV>
<DIV>Here is the Excel command I use</DIV>
<DIV> </DIV>
<DIV>@key+ : : input popup f "Enter filename or leave blank for new file " (Used if user is to give filename)</DIV>
<DIV>
<DIV>@key+ : : f="shopsch.xls"{"" (System used filename)</DIV>
<DIV> </DIV>
<DIV>: : then: mf="c:\programs files\microsoft office\office\excel.exe"<f</DIV>
<DIV> </DIV>
<DIV>Note that in the above neither f nor mf are defined</DIV>
<DIV> </DIV>
<DIV>Running using fp (5.0.15) on a Windows 2003 server network</DIV>
<DIV> </DIV>
<DIV>Hope this helps</DIV>
<DIV> </DIV>
<DIV>Rick Hane</DIV>
<DIV>Controller</DIV>
<DIV>Deluxe Stitcher Company Inc</DIV>
<DIV><A href="http://www.deluxestitcher.com">www.deluxestitcher.com</A></DIV>
<DIV></DIV></DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"><BR>
<DIV style="FONT-SIZE: 13px; FONT-FAMILY: arial, helvetica, sans-serif"><FONT face=Tahoma size=2>
<HR SIZE=1>
<B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> John Esak <john@valar.com><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Harold <haroldef@sbcglobal.net><BR><B><SPAN style="FONT-WEIGHT: bold">Cc:</SPAN></B> list filePro mailing <filepro-list@lists.celestial.com><BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Wed, June 16, 2010 1:46:21 PM<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE: Sort/Selection processing<BR></FONT><BR>It sounds like you might still be in filePro when you're trying to open the<BR>file. If so, you must CLOSE it first. So issue a CLOSE statement and see if<BR>you cn then open the file first. <BR><BR>John<BR><BR>> -----Original Message-----<BR>> From: Harold [mailto:<A href="mailto:haroldef@sbcglobal.net" ymailto="mailto:haroldef@sbcglobal.net">haroldef@sbcglobal.net</A>] <BR>> Sent: Wednesday, June 16, 2010 12:01 PM<BR>> To: <A href="mailto:john@valar.com"
ymailto="mailto:john@valar.com">john@valar.com</A><BR>> Cc: <A href="mailto:filepro-list@lists.celestial.com" ymailto="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</A><BR>> Subject: Re: Sort/Selection processing<BR>> <BR>> On 6/15/2010 3:51 PM, John Esak wrote:<BR>> ><BR>> > Yes, I realized right away that @ts wouldn't have a meaning <BR>> other than Total<BR>> > Records Processed, not Total Records Selected. I think it <BR>> *would* be useful<BR>> > in this context. Not *real* useful... But somewhat, <BR>> maybe... Sometimes...<BR>> > Perhaps. Oh, okay, it's pretty much not to useful a thing <BR>> to know, other<BR>> > than to just know it? Since it has no relation to how many <BR>> you actually<BR>> > select, you couldn't use it for much of anything.<BR>> ><BR>> > John<BR>> ><BR>> <BR>> Hi John,<BR>> <BR>> I am
still working on my problem--I can create the CSV file, <BR>> but haven't been able to <BR>> open the CSV file while in filepro, using Excel, after the <BR>> CSV file has been created.<BR>> <BR>> I use @ts to see how many records have been selected, and as <BR>> each record has been <BR>> sent to the CSV file I increment a variable field rn. When <BR>> rn is equal to @ts I try <BR>> to open CSV.<BR>> <BR>> To prove that @ts is the number of records selected I have <BR>> created the JPG file <BR>> attached. Note at the bottom left where it shows @ts, which <BR>> contains the number of <BR>> records selected, which is that same number as that above.<BR>> <BR>> Take Care,<BR>> <BR>> Harold<BR>> <BR>> ><BR>> ><BR>> >> -----Original Message-----<BR>> >> From: Kenneth Brody [mailto:<A href="mailto:kenbrody@spamcop.net"
ymailto="mailto:kenbrody@spamcop.net">kenbrody@spamcop.net</A>]<BR>> >> Sent: Tuesday, June 15, 2010 3:49 PM<BR>> >> To: <A href="mailto:john@valar.com" ymailto="mailto:john@valar.com">john@valar.com</A><BR>> >> Cc: <A href="mailto:filepro-list@lists.celestial.com" ymailto="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</A><BR>> >> Subject: Re: Sort/Selection processing<BR>> >><BR>> >> On 6/15/2010 2:12 PM, John Esak wrote:<BR>> >> [...]<BR>> >>> I will assume that @ts has no value either on the -v table.<BR>> >> Although, who<BR>> >>> knows (besides Ken :-) maybe it does. In which case, you<BR>> >> could set an<BR>> >>> incrmenting counter for every record encoutnerd selected or<BR>> >> not and when @ts<BR>> >>> equalled this counter, you'd be done with the -v processing.<BR>> >>
[...]<BR>> >><BR>> >> I'd have to check is @TS has any value during sort/select<BR>> >> processing. But,<BR>> >> even if it did, what would it mean?<BR>> >><BR>> >> Consider this:<BR>> >><BR>> >> I hand you my Rolodex, and ask you to pull out all the<BR>> >> clients from New<BR>> >> York. Part-way through, I ask you "how many New York clients<BR>> >> are in my<BR>> >> Rolodex, and have you gotten all of them yet?"<BR>> >><BR>> >> --<BR>> >> Kenneth Brody<BR>> >><BR>> ><BR>> > _______________________________________________<BR>> > Filepro-list mailing list<BR>> > <A href="mailto:Filepro-list@lists.celestial.com" ymailto="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</A><BR>> > http://mailman.celestial.com/mailman/listinfo/filepro-list<BR>>
><BR>> <BR>> <BR>> <BR><BR>_______________________________________________<BR>Filepro-list mailing list<BR><A href="mailto:Filepro-list@lists.celestial.com" ymailto="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</A><BR><A href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target=_blank>http://mailman.celestial.com/mailman/listinfo/filepro-list</A><BR></DIV></DIV></div></body></html>