Re: VFP9 - Save as XLSX

[Alan Bourke]

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 third parties who will almost certainly be 
using MS Office themselves, or automation requirements  then there is only one 
show in town. 


-- 
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm


___
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/1523976722.1024409.1341091408.61040...@webmail.messagingengine.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 - Save as XLSX

[Paul Hill]

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 PROGRESS.
>
> Most of the plants plan production on excel as well.

12 years ago I worked for an large UK/US ticket agency (yes, that one)
and everything was Excel sheets.
Most of these were generated from FoxBASE (yep).

The FoxBASE apps were positively modern compared to the backend.
Ancient VAX systems.
Mostly West-End shows but also events at Twickenham rugby stadium
(80,000+ seats).

-- 
Paul

___
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/cadwx0+lzef26ryuaerbnialjcql6-p3owgxsgx1yr2jjrm2...@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: VFP9 - Save as XLSX

[Stephen Russell]

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, 2018 at 10:58 AM, Frank Cazabon 
wrote:

> 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 <
> srussell...@gmail.com> wrote:
> >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 shot down with no thought past retraining hundreds of
> >users how to do the same thing in a new environment.  Also the
> >inability to
> >leverage macros from older documents.  Last bit was the lack of
> >statistical
> >add-in that excel has for free.  Our engineering and quality teams do a
> >lot
> >with that side of the product outside of sum this column.
> >
> >
> >--
> >Stephen Russell
> >Sr. Analyst
> >Ring Container Technology
> >Oakland TN
> >
> >901.246-0159 cell
> >
> >
> >--- 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/CAJidMYJvgmL0cQwVJka1cYBrWzVvqH_o0eK0i8q8r3xRg=t...@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: VFP9 - Save as XLSX

[Koen Piller]

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 Docs, no
> > sign of MS Office anywhere.
> > ---
>
>
> I have brought that suggestion up at every company I have worked for and
> everywhere it was shot down with no thought past retraining hundreds of
> users how to do the same thing in a new environment.  Also the inability to
> leverage macros from older documents.  Last bit was the lack of statistical
> add-in that excel has for free.  Our engineering and quality teams do a lot
> with that side of the product outside of sum this column.
>
>
> --
> Stephen Russell
> Sr. Analyst
> Ring Container Technology
> Oakland TN
>
> 901.246-0159 cell
>
>
> --- 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/cacuu1suzeaeuxvhqccbgcs4adp2i8j8fm9ey1ka+b5wuqh4...@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: VFP9 - Save as XLSX

[Frank Cazabon]

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
>
>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 shot down with no thought past retraining hundreds of
>users how to do the same thing in a new environment.  Also the
>inability to
>leverage macros from older documents.  Last bit was the lack of
>statistical
>add-in that excel has for free.  Our engineering and quality teams do a
>lot
>with that side of the product outside of sum this column.
>
>
>-- 
>Stephen Russell
>Sr. Analyst
>Ring Container Technology
>Oakland TN
>
>901.246-0159 cell
>
>
>--- 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/b3c00f18-f3ff-411f-8881-6499c1039...@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: VFP9 - Save as XLSX

[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 Docs, no
> sign of MS Office anywhere.
> ---


I have brought that suggestion up at every company I have worked for and
everywhere it was shot down with no thought past retraining hundreds of
users how to do the same thing in a new environment.  Also the inability to
leverage macros from older documents.  Last bit was the lack of statistical
add-in that excel has for free.  Our engineering and quality teams do a lot
with that side of the product outside of sum this column.


-- 
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN

901.246-0159 cell


--- 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/cajidmyj0l1tozouwqg8gf4kfbh9v328zt5giqj8z1ytdyop...@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: VFP9 - Save as XLSX

[Frank Cazabon]

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 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.




I still stand by my statement that every desktop I have ever developed for
from VFP to Web has always had users of spreadsheets that all were excel
since the late 90s.  Before that it was a lot of Excel and some Quatro Pro
as well as 1-2-3.






___
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/978eef0d-4522-282d-cb03-4ccfa52e8...@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: VFP9 - Save as XLSX

[Stephen Russell]

I know nothing about that from years past.  My last 4 employers were all
legit.  Current one gets an audit by our vendor yearly and we just had
another one from our new owner, Michael Dell.



On Tue, Apr 17, 2018 at 9:29 AM, Dave Crozier <da...@flexipol.co.uk> wrote:

> But I wouldn't bet on them all being legal!!
>
> 
>
> Dave Crozier
> Software Development Manager
> Flexipol Packaging Ltd.
>
>
>
> ---
> This communication and the information it contains is intended for the
> person or organisation to whom it is addressed. Its contents are
> confidential and may be protected in law. If you have received this e-mail
> in error you must not copy, distribute or take any action in reliance on
> it. Unauthorised use, copying or disclosure of any of it may be unlawful.
> If you have received this message in error, please notify us immediately by
> telephone or email.
>
> Flexipol Packaging Ltd. has taken every reasonable precaution to minimise
> the risk of virus transmission through email and therefore any files sent
> via e-mail will have been checked for known viruses. However, you are
> advised to run your own virus check before opening any
> attachments received as Flexipol Packaging Ltd will not in any event
> accept any liability whatsoever once an e-mail and/or any attachment is
> received.
>
> It is the responsibility of the recipient to ensure that they have
> adequate virus protection.
>
> Flexipol Packaging Ltd.
> Unit 14 Bentwood Road
> Carrs
> Industrial Estate
> Haslingden
> Rossendale
> Lancashire
> BB4 5HH
>
> Tel:01706-222792
> Fax: 01706-224683
> www.Flexipol.co.uk
> ---
>
> Terms & Conditions:
>
> Notwithstanding delivery and the passing of risk in the goods, the
> property in the goods shall not pass to the buyer until the seller
> Flexipol Packaging Ltd. ("The Company") has received in cash or cleared
> funds payment in full of the price of the goods and all other goods agreed
> to be sold by the seller to the buyer for which payment is then due. Until
> such time as the property in the goods passes to the buyer, the buyer shall
> hold the goods as the seller's fiduciary agent and bailee and keep the
> goods separate from those of the buyer and third parties and properly
> stored protected and insured and identified as the seller's property but
> shall be entitled to resell or use the goods in the ordinary course of its
> 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 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 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.
> >
> > 
>
>
> I still stand by my statement that every desktop I have ever developed for
> from VFP to Web has always had users of spreadsheets that all were excel
> since the late 90s.  Before that it was a lot of Excel and some Quatro Pro
> as well as 1-2-3.
>
>
>
> --
> Stephen Russell
> Sr. Analyst
> Ring Container Technology
> Oakland TN
>
> 901.246-0159 cell
>
>
> --- 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/CAJidMYKRhKBe5TG=g5zvdqwthzqdvo8x0hkk+w5dvj_w78c...@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: VFP9 - Save as XLSX

[Dave Crozier]

But I wouldn't bet on them all being legal!!



Dave Crozier
Software Development Manager
Flexipol Packaging Ltd.



---
This communication and the information it contains is intended for the person 
or organisation to whom it is addressed. Its contents are confidential and may 
be protected in law. If you have received this e-mail in error you must not 
copy, distribute or take any action in reliance on it. Unauthorised use, 
copying or disclosure of any of it may be unlawful. If you have received this 
message in error, please notify us immediately by telephone or email.

Flexipol Packaging Ltd. has taken every reasonable precaution to minimise the 
risk of virus transmission through email and therefore any files sent via 
e-mail will have been checked for known viruses. However, you are advised to 
run your own virus check before opening any
attachments received as Flexipol Packaging Ltd will not in any event accept any 
liability whatsoever once an e-mail and/or any attachment is received.

It is the responsibility of the recipient to ensure that they have adequate 
virus protection.

Flexipol Packaging Ltd.
Unit 14 Bentwood Road
Carrs
Industrial Estate
Haslingden
Rossendale
Lancashire
BB4 5HH

Tel:01706-222792
Fax: 01706-224683
www.Flexipol.co.uk
---

Terms & Conditions:

Notwithstanding delivery and the passing of risk in the goods, the property in 
the goods shall not pass to the buyer until the seller
Flexipol Packaging Ltd. ("The Company") has received in cash or cleared funds 
payment in full of the price of the goods and all other goods agreed to be sold 
by the seller to the buyer for which payment is then due. Until such time as 
the property in the goods passes to the buyer, the buyer shall hold the goods 
as the seller's fiduciary agent and bailee and keep the goods separate from 
those of the buyer and third parties and properly stored protected and insured 
and identified as the seller's property but shall be entitled to resell or use 
the goods in the ordinary course of its 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 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 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.
>
> 


I still stand by my statement that every desktop I have ever developed for from 
VFP to Web has always had users of spreadsheets that all were excel since the 
late 90s.  Before that it was a lot of Excel and some Quatro Pro as well as 
1-2-3.



--
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN

901.246-0159 cell


--- 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/CAJidMYJnUW66quxtNW8oB7u0uno=+8L1K=k0rhq2s9ldxsj...@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.
___
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/18725b8cd2d5d247873a2baf401d4ab2bec70...@ex2010-a-fpl.fpl.LOCAL
** 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 - Save as XLSX

[Stephen Russell]

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 to a
> client who presumably had Excel.
>
> 


I still stand by my statement that every desktop I have ever developed for
from VFP to Web has always had users of spreadsheets that all were excel
since the late 90s.  Before that it was a lot of Excel and some Quatro Pro
as well as 1-2-3.



-- 
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN

901.246-0159 cell


--- 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/CAJidMYJnUW66quxtNW8oB7u0uno=+8L1K=k0rhq2s9ldxsj...@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: VFP9 - Save as XLSX

[Richard Kaye]

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 read from XLSX 
functionality although I have not really used that other than to try it out. 

https://github.com/ggreen86/XLXS-Workbook-Class

--

rk

-Original Message-
From: ProfoxTech  On Behalf Of Desmond Lloyd
Sent: Monday, April 16, 2018 12:18 PM
To: profoxt...@leafe.com
Subject: VFP9 - Save as XLSX

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.  oworkbook.version
shows 16. (we are running Office 365)

Tried the SweetPotato method but it errors out.   Not sure why.

Would someone be kind enough to point me in the right direction,  with some
possible examples...

TIA,
Desmond

___
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/dm5pr10mb12441ee2d800e6a08878d0afd2...@dm5pr10mb1244.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: VFP9 - Save as XLSX

[Dave Crozier]

You could always export in XML format which all newer versions of Excel are 
capable of reading.

Dave Crozier
Software Development Manager
Flexipol Packaging Ltd.



---
This communication and the information it contains is intended for the person 
or organisation to whom it is addressed. Its contents are confidential and may 
be protected in law. If you have received this e-mail in error you must not 
copy, distribute or take any action in reliance on it. Unauthorised use, 
copying or disclosure of any of it may be unlawful. If you have received this 
message in error, please notify us immediately by telephone or email.

Flexipol Packaging Ltd. has taken every reasonable precaution to minimise the 
risk of virus transmission through email and therefore any files sent via 
e-mail will have been checked for known viruses. However, you are advised to 
run your own virus check before opening any
attachments received as Flexipol Packaging Ltd will not in any event accept any 
liability whatsoever once an e-mail and/or any attachment is received.

It is the responsibility of the recipient to ensure that they have adequate 
virus protection.

Flexipol Packaging Ltd.
Unit 14 Bentwood Road
Carrs
Industrial Estate
Haslingden
Rossendale
Lancashire
BB4 5HH

Tel:01706-222792
Fax: 01706-224683
www.Flexipol.co.uk
---

Terms & Conditions:

Notwithstanding delivery and the passing of risk in the goods, the property in 
the goods shall not pass to the buyer until the seller
Flexipol Packaging Ltd. ("The Company") has received in cash or cleared funds 
payment in full of the price of the goods and all other goods agreed to be sold 
by the seller to the buyer for which payment is then due. Until such time as 
the property in the goods passes to the buyer, the buyer shall hold the goods 
as the seller's fiduciary agent and bailee and keep the goods separate from 
those of the buyer and third parties and properly stored protected and insured 
and identified as the seller's property but shall be entitled to resell or use 
the goods in the ordinary course of its 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 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 an  Excel file which was then sent to a client who 
presumably had Excel.

John Weller
01380 723235
07976 393631

>
> This post was to generate XLSX thus they should have excel.
>
> On Mon, Apr 16, 2018 at 2:01 PM, John Weller <j...@johnweller.co.uk>
> 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 brainer expecting it in that this is
> > > a desktop environment and not a server based web farm.


___
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/000c01d3d5bc$ba00f830$2e02e890$@johnweller.co.uk
** 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.
___
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/18725b8cd2d5d247873a2baf401d4ab2bec6e...@ex2010-a-fpl.fpl.LOCAL
** 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 - Save as XLSX

[John Weller]

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

> 
> 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 brainer expecting it in that this is a desktop
> > > environment and not a server based web farm.


___
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/000c01d3d5bc$ba00f830$2e02e890$@johnweller.co.uk
** 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 - Save as XLSX

[Stephen Russell]

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 brainer expecting it in that this is a desktop
> > environment and not a server based web farm.
>
>
[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/cajidmyjtdxeaxu4tdm6e8cgwo3j0p1a-psegjpkt5fetwap...@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: VFP9 - Save as XLSX

[John Weller]

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 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/01d3d5b5$549cb7b0$fdd62710$@johnweller.co.uk
** 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 - Save as XLSX

[Fernando D. Bozzo]

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 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 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 automated conversion tasks.
> >
> >
> >
> > 2018-04-16 18:46 GMT+02:00 Stephen Russell :
> >
> > > 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 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.
> oworkbook.version
> > > >> shows 16. (we are running Office 365)
> > > >>
> > > >> Tried the SweetPotato method but it errors out.   Not sure why.
> > > >>
> > > >> Would someone be kind enough to point me in the right direction,
> with
> > > >> some
> > > >> possible examples...
> > > >>
> > > >> You can copy the contents of the cursor out to .xls only using the
> > > > standard COPY TO ... TYPE XL5
> > > > Then you can use automation to create an .XLSX file.   I'm using
> office
> > > > 365 but I am on version 15 so slightly older so you should be able to
> > > > create an .XLSX file with your version.
> > > >
> > > > #include include\excel.h
> > > > TRUE=.T.
> > > > FALSE=.F.
> > > > oExcel = CREATEOBJECT('excel.application')
> > > > oExcel.Workbooks.Open(myfile)
> > > > cOutfile2 = 'myfilev2.xlsx'
> > > > objexcel.ActiveWorkbook.SaveAs(cOutfile2, xlOpenXMLWorkbook)
> > > >
> > > >
> > > > In excel.h xlOpenXMLWorkbook is 51
> > > >
> > > > HTH,
> > > >
> > > > Peter
> > > >
> > > >
> > > > ,"This communication is intended for the person or organisation to
> whom
> > > it
> > > > is addressed. The contents are confidential and may be protected in
> > law.
> > > > Unauthorised use, copying or disclosure of any of it may be unlawful.
> > If
> > > > you have received this message in error, please notify us immediately
> > by
> > > > telephone or email.
> > > > www.whisperingsmith.com
> > > >
> > > > Whispering Smith Ltd Head Office:61 Great Ducie Street,
> > > >  > > Ducie+Street,=gmail=g>
> > > > Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715
> > > > London Office: 101 St. Martin's Lane,London, WC2N 4AZ  Tel:0207 299
> > 7960
> > > >
> > > >
> > > >
> > > >
[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_jumkcnijvyzpwg01vymb6fn0zamfjdhcm0nalxzoywe...@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: VFP9 - Save as XLSX

[Stephen Russell]

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 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 automated conversion tasks.
>
>
>
> 2018-04-16 18:46 GMT+02:00 Stephen Russell :
>
> > 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 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.  oworkbook.version
> > >> shows 16. (we are running Office 365)
> > >>
> > >> Tried the SweetPotato method but it errors out.   Not sure why.
> > >>
> > >> Would someone be kind enough to point me in the right direction,  with
> > >> some
> > >> possible examples...
> > >>
> > >> You can copy the contents of the cursor out to .xls only using the
> > > standard COPY TO ... TYPE XL5
> > > Then you can use automation to create an .XLSX file.   I'm using office
> > > 365 but I am on version 15 so slightly older so you should be able to
> > > create an .XLSX file with your version.
> > >
> > > #include include\excel.h
> > > TRUE=.T.
> > > FALSE=.F.
> > > oExcel = CREATEOBJECT('excel.application')
> > > oExcel.Workbooks.Open(myfile)
> > > cOutfile2 = 'myfilev2.xlsx'
> > > objexcel.ActiveWorkbook.SaveAs(cOutfile2, xlOpenXMLWorkbook)
> > >
> > >
> > > In excel.h xlOpenXMLWorkbook is 51
> > >
> > > HTH,
> > >
> > > Peter
> > >
> > >
> > > ,"This communication is intended for the person or organisation to whom
> > it
> > > is addressed. The contents are confidential and may be protected in
> law.
> > > Unauthorised use, copying or disclosure of any of it may be unlawful.
> If
> > > you have received this message in error, please notify us immediately
> by
> > > telephone or email.
> > > www.whisperingsmith.com
> > >
> > > Whispering Smith Ltd Head Office:61 Great Ducie Street,
> > >  > Ducie+Street,=gmail=g>
> > > Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715
> > > London Office: 101 St. Martin's Lane,London, WC2N 4AZ  Tel:0207 299
> 7960
> > >
> > >
> > >
> > >
[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/CAJidMYKzuuBWWAU8HCRX3bdk1DSS_oP26qfDFCpE0-+=no1...@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: VFP9 - Save as XLSX

[Ajit Abraham]

+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, even if you only need an unattended
server for automated conversion tasks.



___
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/cb31eddb-b8ef-025b-d01c-31f5cce16...@ua-group.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 - Save as XLSX

[Fernando D. Bozzo]

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 automated conversion tasks.



2018-04-16 18:46 GMT+02:00 Stephen Russell :

> 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 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.  oworkbook.version
> >> shows 16. (we are running Office 365)
> >>
> >> Tried the SweetPotato method but it errors out.   Not sure why.
> >>
> >> Would someone be kind enough to point me in the right direction,  with
> >> some
> >> possible examples...
> >>
> >> You can copy the contents of the cursor out to .xls only using the
> > standard COPY TO ... TYPE XL5
> > Then you can use automation to create an .XLSX file.   I'm using office
> > 365 but I am on version 15 so slightly older so you should be able to
> > create an .XLSX file with your version.
> >
> > #include include\excel.h
> > TRUE=.T.
> > FALSE=.F.
> > oExcel = CREATEOBJECT('excel.application')
> > oExcel.Workbooks.Open(myfile)
> > cOutfile2 = 'myfilev2.xlsx'
> > objexcel.ActiveWorkbook.SaveAs(cOutfile2, xlOpenXMLWorkbook)
> >
> >
> > In excel.h xlOpenXMLWorkbook is 51
> >
> > HTH,
> >
> > Peter
> >
> >
> > ,"This communication is intended for the person or organisation to whom
> it
> > is addressed. The contents are confidential and may be protected in law.
> > Unauthorised use, copying or disclosure of any of it may be unlawful. If
> > you have received this message in error, please notify us immediately by
> > telephone or email.
> > www.whisperingsmith.com
> >
> > Whispering Smith Ltd Head Office:61 Great Ducie Street,
> >  Ducie+Street,=gmail=g>
> > Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715
> > London Office: 101 St. Martin's Lane,London, WC2N 4AZ  Tel:0207 299 7960
> >
> >
> >
> >
[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_jumd4tc4xgzqgumuj+xfwh3ke8chu4tzjg6pvkte1xi...@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: VFP9 - Save as XLSX

[Stephen Russell]

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 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.  oworkbook.version
>> shows 16. (we are running Office 365)
>>
>> Tried the SweetPotato method but it errors out.   Not sure why.
>>
>> Would someone be kind enough to point me in the right direction,  with
>> some
>> possible examples...
>>
>> You can copy the contents of the cursor out to .xls only using the
> standard COPY TO ... TYPE XL5
> Then you can use automation to create an .XLSX file.   I'm using office
> 365 but I am on version 15 so slightly older so you should be able to
> create an .XLSX file with your version.
>
> #include include\excel.h
> TRUE=.T.
> FALSE=.F.
> oExcel = CREATEOBJECT('excel.application')
> oExcel.Workbooks.Open(myfile)
> cOutfile2 = 'myfilev2.xlsx'
> objexcel.ActiveWorkbook.SaveAs(cOutfile2, xlOpenXMLWorkbook)
>
>
> In excel.h xlOpenXMLWorkbook is 51
>
> HTH,
>
> Peter
>
>
> ,"This communication is intended for the person or organisation to whom it
> is addressed. The contents are confidential and may be protected in law.
> Unauthorised use, copying or disclosure of any of it may be unlawful. If
> you have received this message in error, please notify us immediately by
> telephone or email.
> www.whisperingsmith.com
>
> Whispering Smith Ltd Head Office:61 Great Ducie Street,
> 
> Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715
> London Office: 101 St. Martin's Lane,London, WC2N 4AZ  Tel:0207 299 7960
>
>
>
>
[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/CAJidMYLnhqRHJb-s3Z49m_Bt=1isuhzfncps2ibtz4dey77...@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: VFP9 - Save as XLSX

[Koen Piller]

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 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.  oworkbook.version
> > shows 16. (we are running Office 365)
> >
> > Tried the SweetPotato method but it errors out.   Not sure why.
> >
> > Would someone be kind enough to point me in the right direction,  with
> some
> > possible examples...
> >
> You can copy the contents of the cursor out to .xls only using the
> standard COPY TO ... TYPE XL5
> Then you can use automation to create an .XLSX file.   I'm using office
> 365 but I am on version 15 so slightly older so you should be able to
> create an .XLSX file with your version.
>
> #include include\excel.h
> TRUE=.T.
> FALSE=.F.
> oExcel = CREATEOBJECT('excel.application')
> oExcel.Workbooks.Open(myfile)
> cOutfile2 = 'myfilev2.xlsx'
> objexcel.ActiveWorkbook.SaveAs(cOutfile2, xlOpenXMLWorkbook)
>
>
> In excel.h xlOpenXMLWorkbook is 51
>
> HTH,
>
> Peter
>
>
> ,"This communication is intended for the person or organisation to whom it
> is addressed. The contents are confidential and may be protected in law.
> Unauthorised use, copying or disclosure of any of it may be unlawful. If
> you have received this message in error, please notify us immediately by
> telephone or email.
>
> www.whisperingsmith.com
>
> Whispering Smith Ltd Head Office:61 Great Ducie Street,
> 
> Manchester M3 1RR.
> Tel:0161 831 3700
> Fax:0161 831 3715
>
> London Office: 101 St. Martin's Lane,London, WC2N 4AZ  Tel:0207 299 7960
>
>
>
>
[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/cacuu1sv92-4md1ashjp2gx0xdaty4afakrkg4fay-2ynfdk...@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: VFP9 - Save as XLSX

[Peter Cushing]

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.  oworkbook.version
shows 16. (we are running Office 365)

Tried the SweetPotato method but it errors out.   Not sure why.

Would someone be kind enough to point me in the right direction,  with some
possible examples...

You can copy the contents of the cursor out to .xls only using the 
standard COPY TO ... TYPE XL5
Then you can use automation to create an .XLSX file.   I'm using office 
365 but I am on version 15 so slightly older so you should be able to 
create an .XLSX file with your version.


#include include\excel.h
TRUE=.T.
FALSE=.F.
oExcel = CREATEOBJECT('excel.application')
oExcel.Workbooks.Open(myfile)
cOutfile2 = 'myfilev2.xlsx'
objexcel.ActiveWorkbook.SaveAs(cOutfile2, xlOpenXMLWorkbook)


In excel.h xlOpenXMLWorkbook is 51

HTH,

Peter


,"This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. 


www.whisperingsmith.com

Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. 
Tel:0161 831 3700 
Fax:0161 831 3715 


London Office: 101 St. Martin's Lane,London, WC2N 4AZ  Tel:0207 299 7960




___
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/58217eca-a607-ef6b-38ee-817c05574...@whisperingsmith.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 - Save as XLSX

[Fernando D. Bozzo]

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
> 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.  oworkbook.version
> shows 16. (we are running Office 365)
>
> Tried the SweetPotato method but it errors out.   Not sure why.
>
> Would someone be kind enough to point me in the right direction,  with some
> possible examples...
>
> TIA,
> Desmond
>
>
> --- 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/CAGQ_Jums5wHcKXz5q+_Whc6dkeJbTiVO5WJuwtO=gfnykoe...@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: VFP9 - Save as XLSX

[Koen Piller]

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 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.  oworkbook.version
> shows 16. (we are running Office 365)
>
> Tried the SweetPotato method but it errors out.   Not sure why.
>
> Would someone be kind enough to point me in the right direction,  with some
> possible examples...
>
> TIA,
> Desmond
>
>
> --- 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/CACUu1SuCMy_eBGp3kWX+x6jGebY6Hohtn=bawq9f0v-cjan...@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.