Re: VFP9 - Save as XLSX

We have hundreds of customers across everything from aerospace to meat packing to game development, and almost without exception they're on MS Office, and latterly Office 365. If your requirements go beyond very simple documents in any way and/or you have requirements to exchange them with

Re: VFP9 - Save as XLSX

On 17 April 2018 at 18:04, Stephen Russell wrote: > I work for a company with 20 plants USA by summer the newest one will be > on-line, Another in CA and one UK. > > Our month end close for accounting use to take 300 excel documents 7 years > ago and now only 15. That is

Re: VFP9 - Save as XLSX

I work for a company with 20 plants USA by summer the newest one will be on-line, Another in CA and one UK. Our month end close for accounting use to take 300 excel documents 7 years ago and now only 15. That is PROGRESS. Most of the plants plan production on excel as well. On Tue, Apr 17,

Re: VFP9 - Save as XLSX

I believe Vilhelm has also import procedures for these procedures. Op di 17 apr. 2018 om 17:15 schreef Stephen Russell > On Tue, Apr 17, 2018 at 9:45 AM, Frank Cazabon > wrote: > > > I am seeing more and more clients using Libre Office or Google

Re: VFP9 - Save as XLSX

Different types of clients. Mine tend to be small companies with sometimes less than 10 employees and no legacy of office documents. On 17 April 2018 11:14:57 GMT-04:00, Stephen Russell wrote: >On Tue, Apr 17, 2018 at 9:45 AM, Frank Cazabon >

Re: VFP9 - Save as XLSX

On Tue, Apr 17, 2018 at 9:45 AM, Frank Cazabon wrote: > I am seeing more and more clients using Libre Office or Google Docs, no > sign of MS Office anywhere. > --- I have brought that suggestion up at every company I have worked for and everywhere it was

Re: VFP9 - Save as XLSX

I am seeing more and more clients using Libre Office or Google Docs, no sign of MS Office anywhere. Frank. Frank Cazabon On 17/04/2018 10:27 AM, Stephen Russell wrote: On Mon, Apr 16, 2018 at 2:54 PM, John Weller wrote: You said that you couldn't remember anyone in

Re: VFP9 - Save as XLSX

; business. Until such time as the property in the goods passes to the buyer > the seller shall be entitled at any time > > -----Original Message- > From: ProFox <profox-boun...@leafe.com> On Behalf Of Stephen Russell > Sent: 17 April 2018 15:28 > To: ProFox Email

RE: VFP9 - Save as XLSX

17 April 2018 15:28 To: ProFox Email List <profox@leafe.com> Subject: Re: VFP9 - Save as XLSX On Mon, Apr 16, 2018 at 2:54 PM, John Weller <j...@johnweller.co.uk> wrote: > You said that you couldn't remember anyone in a business environment > that didn't have Excel. I came across many de

Re: VFP9 - Save as XLSX

On Mon, Apr 16, 2018 at 2:54 PM, John Weller wrote: > You said that you couldn't remember anyone in a business environment that > didn't have Excel. I came across many desks where the user was running a > VFP app to produce an output as an Excel file which was then sent

RE: VFP9 - Save as XLSX

In addition to other suggestions on this thread, there is also a VFPx project that allows you to create XLSX files without Excel being installed. No COM automation involved. One of its core methods creates the output from a cursor or table. It's pretty easy to use and performs well. It also has

RE: VFP9 - Save as XLSX

fe.com> On Behalf Of John Weller Sent: 16 April 2018 20:54 To: profox@leafe.com Subject: RE: VFP9 - Save as XLSX You said that you couldn't remember anyone in a business environment that didn't have Excel. I came across many desks where the user was running a VFP app to produce an output as

RE: VFP9 - Save as XLSX

You said that you couldn't remember anyone in a business environment that didn't have Excel. I came across many desks where the user was running a VFP app to produce an output as an Excel file which was then sent to a client who presumably had Excel. John Weller 01380 723235 07976 393631 >

Re: VFP9 - Save as XLSX

This post was to generate XLSX thus they should have excel. On Mon, Apr 16, 2018 at 2:01 PM, John Weller wrote: > I can  > > John Weller > 01380 723235 > 07976 393631 > > > In business consulting, I cannot remember ANYONE that didn't have excel > > installed. It is a no

RE: VFP9 - Save as XLSX

I can  John Weller 01380 723235 07976 393631 > In business consulting, I cannot remember ANYONE that didn't have excel > installed. It is a no brainer expecting it in that this is a desktop > environment and not a server based web farm. ___ Post

Re: VFP9 - Save as XLSX

In Business Assurance, with 1000's of licences and CIOs looking for cutting costs down, I can assure you that I know some people that do not have Excel, and of course Excel is not installed on all +300 servers. 2018-04-16 20:33 GMT+02:00 Stephen Russell : > In busienss

Re: VFP9 - Save as XLSX

In busienss consulting, I cannot remember ANYONE that didn't have excel installed. It is a no brainer expecting it in that this is a desktop environment and not a server based web farm. On Mon, Apr 16, 2018 at 11:50 AM, Fernando D. Bozzo wrote: > The adventage of Vilhelm's

Re: VFP9 - Save as XLSX

+1 On 16/04/2018 19:50, Fernando D. Bozzo wrote: The adventage of Vilhelm's method is that he manipulates the XLSX file without Excel (at least for reading, didn't test with writing) Not needing Excel is really a Plus, because you need an Excel license in each machine that you need to use it,

Re: VFP9 - Save as XLSX

The adventage of Vilhelm's method is that he manipulates the XLSX file without Excel (at least for reading, didn't test with writing) Not needing Excel is really a Plus, because you need an Excel license in each machine that you need to use it, even if you only need an unattended server for

Re: VFP9 - Save as XLSX

Or learn how to manipulate Excel as a com object and have Excel bring in the data for you into the modern sheet format. A for loop within a for loop to get rows and columns. On Mon, Apr 16, 2018 at 11:32 AM, Peter Cushing < pcush...@whisperingsmith.com> wrote: > On 16/04/2018 17:17, Desmond

Re: VFP9 - Save as XLSX

Look for Vilhelm’s blog he has published several procedures for this with examples Easy Regards Koen Op ma 16 apr. 2018 om 18:33 schreef Peter Cushing < pcush...@whisperingsmith.com> > On 16/04/2018 17:17, Desmond Lloyd wrote: > > Good Morning, > > > > Need to be able to copy the contents of a

Re: VFP9 - Save as XLSX

On 16/04/2018 17:17, Desmond Lloyd wrote: Good Morning, Need to be able to copy the contents of a cursor to an Excel file, but it needs to be in the xlsx. Am a newbie to Excel Automation and have read that you can saveas, and it will save in the latest format. Well mine doesn't.

Re: VFP9 - Save as XLSX

Hi Desmond: In Vilhelm's Blog there are some Excel import/export functions: http://praisachion.blogspot.com.es/ Regards.- 2018-04-16 18:17 GMT+02:00 Desmond Lloyd : > Good Morning, > > Need to be able to copy the contents of a cursor to an Excel file, but it >

Re: VFP9 - Save as XLSX

You are advised to download and install Vilhelm’s excel procedures. They come with examples. Regards Koen Op ma 16 apr. 2018 om 18:17 schreef Desmond Lloyd > Good Morning, > > Need to be able to copy the contents of a cursor to an Excel file, but it > needs to be in