Re: VFP9 and Windows 10 PDF printer
You can make a donation to Cesar Chalom if you like it that much. Thierry Nivelet http://foxincloud.com/ Give your VFP app a second life in the cloud > Le 26 avr. 2017 à 23:53, Paul H. Tarver a écrit : > > I've been using FoxyPreviewer for a couple of years now and I love it. > Haven't tried XFRX yet. > > Are there any advantages to one or the other? > > Paul H. Tarver > Tarver Program Consultants, Inc. > > > > -Original Message- > From: Rick Schummer [mailto:pro...@whitelightcomputing.com] > Sent: Tuesday, April 25, 2017 4:48 PM > To: profoxt...@leafe.com > Subject: RE: VFP9 and Windows 10 PDF printer > > You might save yourself some time by looking at FoxyPreviewer > (https://foxypreviewer.codeplex.com/) or XFRX (http://eqeus.com/), which > make creating PDFs trivial. > > Rick > White Light Computing, Inc. > > www.whitelightcomputing.com > > > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Mike > McCann > Sent: Wednesday, April 12, 2017 05:37 > To: profoxt...@leafe.com > Subject: VFP9 and Windows 10 PDF printer > > Anyone have experience with printing regular FRX reports to the Window 10 > PDF and directing to a file automatically (i.e. no user dialog)? > > Thanks, > > Long time lurker, > > Mike > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/3c2c193e-5975-4ea3-bd5c-6703477fe...@foxincloud.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: VFP9 and Windows 10 PDF printer
I use XFRX and it works well. Probably the biggest difference is that XFRX is not free. Mike Copeland Paul H. Tarver wrote: I've been using FoxyPreviewer for a couple of years now and I love it. Haven't tried XFRX yet. Are there any advantages to one or the other? Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: Rick Schummer [mailto:pro...@whitelightcomputing.com] Sent: Tuesday, April 25, 2017 4:48 PM To: profoxt...@leafe.com Subject: RE: VFP9 and Windows 10 PDF printer You might save yourself some time by looking at FoxyPreviewer (https://foxypreviewer.codeplex.com/) or XFRX (http://eqeus.com/), which make creating PDFs trivial. Rick White Light Computing, Inc. www.whitelightcomputing.com -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Mike McCann Sent: Wednesday, April 12, 2017 05:37 To: profoxt...@leafe.com Subject: VFP9 and Windows 10 PDF printer Anyone have experience with printing regular FRX reports to the Window 10 PDF and directing to a file automatically (i.e. no user dialog)? Thanks, Long time lurker, Mike [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/25033eae-ffae-12ab-367a-492f39759...@ggisoft.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: VFP9 and Windows 10 PDF printer
I've been using FoxyPreviewer for a couple of years now and I love it. Haven't tried XFRX yet. Are there any advantages to one or the other? Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: Rick Schummer [mailto:pro...@whitelightcomputing.com] Sent: Tuesday, April 25, 2017 4:48 PM To: profoxt...@leafe.com Subject: RE: VFP9 and Windows 10 PDF printer You might save yourself some time by looking at FoxyPreviewer (https://foxypreviewer.codeplex.com/) or XFRX (http://eqeus.com/), which make creating PDFs trivial. Rick White Light Computing, Inc. www.whitelightcomputing.com -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Mike McCann Sent: Wednesday, April 12, 2017 05:37 To: profoxt...@leafe.com Subject: VFP9 and Windows 10 PDF printer Anyone have experience with printing regular FRX reports to the Window 10 PDF and directing to a file automatically (i.e. no user dialog)? Thanks, Long time lurker, Mike [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/14d001d2bed7$98770a30$c9651e90$@tpcqpc.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Reading from SQLite
.NULL. is a perfectly valid date. If you're getting numbers, you're likely getting dates stored as days since some arbitrary date. Try: select datetime(yourfield,'unixepoch','localtime') from yourtable; On Wed, Apr 26, 2017 at 4:23 PM, José Olavo Cerávolo wrote: > Hi Guys, > I sent a message but it guess it was misplaced.I am trying to read a SQLite > database, but I have problems with the data.I can connect to it, read the > tables, but the values are messed up.I can't get the Dates, it comes out as > .NULL or with weird numbers.I've looked at the documentation, but nothing is > working.I am using the SQLite ODBC for SQLite version 3. > Thanks in advance, > Jose. > José Olavo Cerávolohttp://www.ceravoloconsulting.com/ > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cacw6n4ted4w_w0ik59nd+c30yh+tnqhn6gfdq+zgesxuymt...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Reading from SQLite
You may have the difficulty of a VFP date is not a SQL date. getdate() is the system datetime. -- convert a date to String SELECT convert(varchar(25), getdate(), 120) -- date part only SELECT CONVERT(date, getdate()) On Wed, Apr 26, 2017 at 3:33 PM, Richard Kaye wrote: > Whil Hentzen wrote an eBook on working with SQLLite. > > http://www.hentzenwerke.com/catalog/sqlite2gb.htm > > > -- > > rk > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of José > Olavo Cerávolo > Sent: Wednesday, April 26, 2017 4:24 PM > To: profoxt...@leafe.com > Subject: Reading from SQLite > > Hi Guys, > I sent a message but it guess it was misplaced.I am trying to read a > SQLite database, but I have problems with the data.I can connect to it, > read the tables, but the values are messed up.I can't get the Dates, it > comes out as .NULL or with weird numbers.I've looked at the documentation, > but nothing is working.I am using the SQLite ODBC for SQLite version 3. > Thanks in advance, > Jose. > José Olavo Cerávolohttp://www.ceravoloconsulting.com/ > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmyjnqutisyb+-ta__yjqjtjf9cwvx+fn8tg46a3u+ri...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Reading from SQLite
Whil Hentzen wrote an eBook on working with SQLLite. http://www.hentzenwerke.com/catalog/sqlite2gb.htm -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of José Olavo Cerávolo Sent: Wednesday, April 26, 2017 4:24 PM To: profoxt...@leafe.com Subject: Reading from SQLite Hi Guys, I sent a message but it guess it was misplaced.I am trying to read a SQLite database, but I have problems with the data.I can connect to it, read the tables, but the values are messed up.I can't get the Dates, it comes out as .NULL or with weird numbers.I've looked at the documentation, but nothing is working.I am using the SQLite ODBC for SQLite version 3. Thanks in advance, Jose. José Olavo Cerávolohttp://www.ceravoloconsulting.com/ ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/bn4pr10mb09136f1044bff4c70fa800a6d2...@bn4pr10mb0913.namprd10.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Reading from SQLite
Hi Guys, I sent a message but it guess it was misplaced.I am trying to read a SQLite database, but I have problems with the data.I can connect to it, read the tables, but the values are messed up.I can't get the Dates, it comes out as .NULL or with weird numbers.I've looked at the documentation, but nothing is working.I am using the SQLite ODBC for SQLite version 3. Thanks in advance, Jose. José Olavo Cerávolohttp://www.ceravoloconsulting.com/ --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/520223282.7828411.1493238211...@mail.yahoo.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Getting count of rows in a text file -- best approach?
|My experience was moving PDF files in and out of SQLServer tables - found an abrupt truncation at the 16,777,184 mark... Brant Layton| |480.964.1316| On 4/26/2017 12:57 PM, profoxtech-requ...@leafe.com wrote: RE: Getting count of rows in a text file -- best approach? --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cb75d8db-8dda-c4cf-8d04-66b77a17f...@futureone.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Excel automation to get the SUM("R:R")
Looks to me like your current solution is storing a formula in a remote cell which you said you wanted to avoid. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of mbsoftwaresoluti...@mbsoftwaresolutions.com Sent: Wednesday, April 26, 2017 11:56 AM To: profoxt...@leafe.com Subject: RE: Excel automation to get the SUM("R:R") Thanks, Richard. I may try that. Here's what I had for now: WITH oExcel.ActiveSheet as EXCEL.Worksheet .Range("AA96").Formula = "=COUNTA(R:R)" DetailClaims = .Range("AA96").Value - 1 .Range("AA97").Formula = "=SUM(Q:Q)" DetailCharges = .Range("AA97").Value .Range("AA98").Formula = "=SUM(R:R)" DetailCaid = .Range("AA98").Value .Range("AA99").Formula = "=SUM(S:S)" DetailCare = .Range("AA99").Value ENDWITH && oExcel.ActiveSheet as EXCEL.Worksheet My DetailClaims logic is wrong though; it's counting ALL rows in the column, and I just wanted to the populated count. Any ideas on that one? Honestly I saw On 2017-04-26 10:15, Richard Kaye wrote: > Here's what I dummied up at the command line. You just need to get the > proper cells in the range object. > > lox=CREATEOBJECT([excel.application]) > lox.Visible=.t. > lox.Workbooks.Add() > los=lox.ActiveSheet > lor=los.Range([a1],[a10]) > ?lox.WorksheetFunction.Sum(lor) > > -- > > rk > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of > mbsoftwaresoluti...@mbsoftwaresolutions.com > Sent: Wednesday, April 26, 2017 10:05 AM > To: profoxt...@leafe.com > Subject: Excel automation to get the SUM("R:R") > > Excel 2013, VFP9SP2 > > Range Object model: > https://msdn.microsoft.com/en-us/library/office/ff838238.aspx > > I've got my handy "Microsoft Office Automation With Visual Foxpro" book > out from HWP, trying to see where I can get the value of a range. In > this case, when I just select the entire column, Excel tells me the SUM > of all of the values in the column at the bottom. I need that number. > I don't want to do some sort of loop; rather, I want to basically say > from VFP: 'return the SUM("R:R").' I've looked at the object model > above and there doesn't appear to be a .Sum to tag onto the end of the > Range object (like you might think of with DotNet stuff). Also, I > don't > want to create a formula in some other remote cell and then read that, > although that's my Plan B for now. > > Ideas? > > tia! > --Mike > > > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/bn4pr10mb0913655c7873c7318675c821d2...@bn4pr10mb0913.namprd10.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Getting count of rows in a text file -- best approach?
Sure looks like you can load larger than 16MB. Though the help file does say a 16MB limit on memory variables. Fred On Wed, Apr 26, 2017 at 11:44 AM, < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > On 2017-04-26 12:31, Brant E. Layton wrote: > >> Just a reminder - STRTOFILE and FILETOSTR are limited by the size of a >> memory variable - 16,384K bytes (16,777.184 bytes). >> >> Had to fix some software that was truncating PDF files at 16 MB... >> || >> > > > Looked up the Visual Foxpro System Capabilities: > Maximum # of characters per character string or memory variable. = > 16,777,184 > > > That seems odd. I thought I had tested with a file larger than 16 MB and > gotten correct numbers? > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajcbksrwspdzwdz3figr2v9crscbekurg+jxjqyd7ygxeup...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Codeplex is shutting down, VFPX.org is spinning up
I haven't seen any commentary from Jim Nelson, Thor Master, as to his plans to adapt Thor to the Git world. He has indicated elsewhere that he is heading towards retirement. Whenever anyone asks a question about changes to Thor, his more recent replies have indicated that he feels it's a pretty mature product and he is not planning on making any significant changes to it. This probably qualifies as a pretty significant change and I would guess that the community will need to step up and find a new Thor Master. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Fernando D. Bozzo Sent: Wednesday, April 26, 2017 3:03 PM To: profoxt...@leafe.com Subject: Re: Codeplex is shutting down, VFPX.org is spinning up Yes, I mean the auto-update feature of the projects. 2017-04-26 20:39 GMT+02:00 : > You mean so that it's still self-updating? > > On 2017-04-26 12:01, Fernando D. Bozzo wrote: > >> I suppose that it will need some rework to work with Github >> >> El 26/4/2017 5:59 p. m., >> escribió: >> >> On 2017-03-31 20:51, Fernando D. Bozzo wrote: >> >> No shit... moving all the projects will be a hard. Binaries, version >>> history, documentation, bye bye Thor :_( >> >> Why would you say "bye bye Thor" ?? >> ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/bn4pr10mb09135f01f9d6a9379366e497d2...@bn4pr10mb0913.namprd10.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Codeplex is shutting down, VFPX.org is spinning up
Yes, I mean the auto-update feature of the projects. 2017-04-26 20:39 GMT+02:00 : > You mean so that it's still self-updating? > > > On 2017-04-26 12:01, Fernando D. Bozzo wrote: > >> I suppose that it will need some rework to work with Github >> >> >> El 26/4/2017 5:59 p. m., >> escribió: >> >> On 2017-03-31 20:51, Fernando D. Bozzo wrote: >> >> No shit... moving all the projects will be a hard. Binaries, version >>> history, documentation, bye bye Thor :_( >>> >>> >> >> Why would you say "bye bye Thor" ?? >> >> [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAGQ_JunpBdD-OWM8fRSgyR0JHFxD4-QBLyOv=CN1=PgSYFJu=q...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Getting count of rows in a text file -- best approach?
On 2017-04-26 12:31, Brant E. Layton wrote: Just a reminder - STRTOFILE and FILETOSTR are limited by the size of a memory variable - 16,384K bytes (16,777.184 bytes). Had to fix some software that was truncating PDF files at 16 MB... || Looked up the Visual Foxpro System Capabilities: Maximum # of characters per character string or memory variable. = 16,777,184 That seems odd. I thought I had tested with a file larger than 16 MB and gotten correct numbers? ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5f473e1d8f5d2390761dfe07a486c...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Codeplex is shutting down, VFPX.org is spinning up
You mean so that it's still self-updating? On 2017-04-26 12:01, Fernando D. Bozzo wrote: I suppose that it will need some rework to work with Github El 26/4/2017 5:59 p. m., escribió: On 2017-03-31 20:51, Fernando D. Bozzo wrote: No shit... moving all the projects will be a hard. Binaries, version history, documentation, bye bye Thor :_( Why would you say "bye bye Thor" ?? [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/bfd106f2558ba21996ecca7c27c5a...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Getting count of rows in a text file -- best approach?
Just a reminder - STRTOFILE and FILETOSTR are limited by the size of a memory variable - 16,384K bytes (16,777.184 bytes). Had to fix some software that was truncating PDF files at 16 MB... || |Brant Layton| |480.964.1316| On 4/25/2017 6:00 PM, profoxtech-requ...@leafe.com wrote: RE: Getting count of rows in a text file -- best approach? --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/4b337c54-d2b2-a698-828a-b15bfad70...@futureone.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Codeplex is shutting down, VFPX.org is spinning up
I suppose that it will need some rework to work with Github El 26/4/2017 5:59 p. m., escribió: On 2017-03-31 20:51, Fernando D. Bozzo wrote: > No shit... moving all the projects will be a hard. Binaries, version > history, documentation, bye bye Thor :_( > Why would you say "bye bye Thor" ?? [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cagq_junzn1ugxdo+pj3ccwh-liuxj4bh413mdexm0blkf8b...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Codeplex is shutting down, VFPX.org is spinning up
On 2017-03-31 20:51, Fernando D. Bozzo wrote: No shit... moving all the projects will be a hard. Binaries, version history, documentation, bye bye Thor :_( Why would you say "bye bye Thor" ?? ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/bcf8097f608cf957bb81e0908bc5b...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Excel automation to get the SUM("R:R")
Ignore that last lineI fixed it with COUNTA. Just forgot to delete that part before pressing "Send" On 2017-04-26 11:55, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: My DetailClaims logic is wrong though; it's counting ALL rows in the column, and I just wanted to the populated count. Any ideas on that one? Honestly I saw ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/b84b778f8c221b744896f8c3a6ef0...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Excel automation to get the SUM("R:R")
Thanks, Richard. I may try that. Here's what I had for now: WITH oExcel.ActiveSheet as EXCEL.Worksheet .Range("AA96").Formula = "=COUNTA(R:R)" DetailClaims = .Range("AA96").Value - 1 .Range("AA97").Formula = "=SUM(Q:Q)" DetailCharges = .Range("AA97").Value .Range("AA98").Formula = "=SUM(R:R)" DetailCaid = .Range("AA98").Value .Range("AA99").Formula = "=SUM(S:S)" DetailCare = .Range("AA99").Value ENDWITH && oExcel.ActiveSheet as EXCEL.Worksheet My DetailClaims logic is wrong though; it's counting ALL rows in the column, and I just wanted to the populated count. Any ideas on that one? Honestly I saw On 2017-04-26 10:15, Richard Kaye wrote: Here's what I dummied up at the command line. You just need to get the proper cells in the range object. lox=CREATEOBJECT([excel.application]) lox.Visible=.t. lox.Workbooks.Add() los=lox.ActiveSheet lor=los.Range([a1],[a10]) ?lox.WorksheetFunction.Sum(lor) -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of mbsoftwaresoluti...@mbsoftwaresolutions.com Sent: Wednesday, April 26, 2017 10:05 AM To: profoxt...@leafe.com Subject: Excel automation to get the SUM("R:R") Excel 2013, VFP9SP2 Range Object model: https://msdn.microsoft.com/en-us/library/office/ff838238.aspx I've got my handy "Microsoft Office Automation With Visual Foxpro" book out from HWP, trying to see where I can get the value of a range. In this case, when I just select the entire column, Excel tells me the SUM of all of the values in the column at the bottom. I need that number. I don't want to do some sort of loop; rather, I want to basically say from VFP: 'return the SUM("R:R").' I've looked at the object model above and there doesn't appear to be a .Sum to tag onto the end of the Range object (like you might think of with DotNet stuff). Also, I don't want to create a formula in some other remote cell and then read that, although that's my Plan B for now. Ideas? tia! --Mike [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/776895f4a76cfb25a9f2b4d59a0b6...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Excel automation to get the SUM("R:R")
Here's what I dummied up at the command line. You just need to get the proper cells in the range object. lox=CREATEOBJECT([excel.application]) lox.Visible=.t. lox.Workbooks.Add() los=lox.ActiveSheet lor=los.Range([a1],[a10]) ?lox.WorksheetFunction.Sum(lor) -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of mbsoftwaresoluti...@mbsoftwaresolutions.com Sent: Wednesday, April 26, 2017 10:05 AM To: profoxt...@leafe.com Subject: Excel automation to get the SUM("R:R") Excel 2013, VFP9SP2 Range Object model: https://msdn.microsoft.com/en-us/library/office/ff838238.aspx I've got my handy "Microsoft Office Automation With Visual Foxpro" book out from HWP, trying to see where I can get the value of a range. In this case, when I just select the entire column, Excel tells me the SUM of all of the values in the column at the bottom. I need that number. I don't want to do some sort of loop; rather, I want to basically say from VFP: 'return the SUM("R:R").' I've looked at the object model above and there doesn't appear to be a .Sum to tag onto the end of the Range object (like you might think of with DotNet stuff). Also, I don't want to create a formula in some other remote cell and then read that, although that's my Plan B for now. Ideas? tia! --Mike [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/bn4pr10mb0913d36fc3e0f8011b08eb2bd2...@bn4pr10mb0913.namprd10.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Excel automation to get the SUM("R:R")
Excel 2013, VFP9SP2 Range Object model: https://msdn.microsoft.com/en-us/library/office/ff838238.aspx I've got my handy "Microsoft Office Automation With Visual Foxpro" book out from HWP, trying to see where I can get the value of a range. In this case, when I just select the entire column, Excel tells me the SUM of all of the values in the column at the bottom. I need that number. I don't want to do some sort of loop; rather, I want to basically say from VFP: 'return the SUM("R:R").' I've looked at the object model above and there doesn't appear to be a .Sum to tag onto the end of the Range object (like you might think of with DotNet stuff). Also, I don't want to create a formula in some other remote cell and then read that, although that's my Plan B for now. Ideas? tia! --Mike ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/d24cf68df7394a897d18582951c1b...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Codeplex is shutting down, VFPX.org is spinning up
On 2017-04-25 17:48, Rick Schummer wrote: And it will be forwarded to the new home of VFPX just as soon as we get it firmly established. The migration is underway already. Rick White Light Computing, Inc. www.whitelightcomputing.com Thanks ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/47ec1407e37218255e21c280d0b4a...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.