Re: Cannot import XLSX

2014-05-09 Thread Ajit Abraham
Hi Wes, If you want to save a xls(x) file into .dbf (IV) format from within Excel, then use the following. http://exceltodbf.sourceforge.net/ I use it in Excel 2010. Regards Ajit Abraham On 5/9/2014 10:04 PM, Wes Wilson wrote: Is there a way to turn an XLSX into an XLS or some other forma

Re: [NF]Get Data From Cloud Service

2014-05-09 Thread Kurt @ VR-FX
That reminds me of a client at my previous job. There data was BIG - and my BOSS did the Exporting of Data. Problem was - some files had too many records - and i think the limit was like 65K records directly exportable to Excel. So - then it becomes cumbersome export the records beyond that. S

Re: [NF]Get Data From Cloud Service

2014-05-09 Thread Jeff Johnson
On 5/9/2014 2:59 PM, M Jarvis wrote: On Fri, May 9, 2014 at 2:49 PM, Jeff Johnson wrote: I asked them, who owns the data and they said the customer. Should a customer have to pay to get their data if they want to switch applications? It is not in any agreement that they agreed to pay for this

Re: [NF]Get Data From Cloud Service

2014-05-09 Thread M Jarvis
On Fri, May 9, 2014 at 2:49 PM, Jeff Johnson wrote: > I asked them, who owns the data and they said the customer. > > Should a customer have to pay to get their data if they want to switch > applications? It is not in any agreement that they agreed to pay for this. > > What do you think about tha

[NF]Get Data From Cloud Service

2014-05-09 Thread Jeff Johnson
I have a customer that uses a cloud application that I am converting to my application. When we requested they export the data they said a) they were not able to give me file structures (I'm okay with this, though) and b) it would cost development time for them to build an export. I asked the

RE: Cannot import XLSX

2014-05-09 Thread Darren
I haven't looked at Craig's code but as a side point it is interesting to note the format of the office files. Rename one to .zip extension and unzip it. You 'll see lots of stuff that is "easy" to deal with. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Beha

Re: Cannot import XLSX

2014-05-09 Thread Frank Cazabon
On 09/05/2014 03:04 PM, Wes Wilson wrote: Is there a way to turn an XLSX into an XLS or some other format that VFP can import. Check out Craig's blog on how to work with the newer excel formats: http://www.sweetpotatosoftware.com/spsblog/2008/09/30/UsingExcel2007FileFormatsInVFP90.aspx wor

RE: Cannot import XLSX

2014-05-09 Thread Allen
You can get XLSX in if you createobject("excel.application"). Maybe get the saveas if you want to do that way. Excel can also save as XLS if doing it in VFP is not required. Didn't Craig Boyd make an excel class? Al -Original Message- Is there a way to turn an XLSX into an XLS or some oth

Cannot import XLSX

2014-05-09 Thread Wes Wilson
Is there a way to turn an XLSX into an XLS or some other format that VFP can import.   Wes Wilson, President ERW Custom Programming, Inc. Crescent Lake Plaza 5459  Elizabeth Lake Rd. Waterford, MI 48327 (248) 683-4182 www.erw.com   weswil...@erw.com   Programmers Wanted Programmers Wanted

Re: Prevent multiple selections in listbox

2014-05-09 Thread Lew Schwartz
Sounds right just didn't see it. Begins with "m," right? On May 9, 2014 2:22 PM, "Dave Thayer" wrote: > On Fri, May 9, 2014 at 12:15 PM, Lew Schwartz wrote: > > Is there a simple way to prevent multiple selections in a listbox (ie > > nothing happens if the shift or ctrl keys are held down)

Re: Prevent multiple selections in listbox

2014-05-09 Thread Dave Thayer
On Fri, May 9, 2014 at 12:15 PM, Lew Schwartz wrote: > Is there a simple way to prevent multiple selections in a listbox (ie > nothing happens if the shift or ctrl keys are held down). myListBox.MultiSelect = .F. perhaps? Dave Thayer Denver, CO ___ P

RE: Prevent multiple selections in listbox

2014-05-09 Thread Richard Kaye
Trap the keystroke in the mouse down event? -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Lew Schwartz Sent: Friday, May 09, 2014 2:15 PM To: profoxt...@leafe.com Subject: Prevent multiple selections in listbox Is there a simple way to preve

Prevent multiple selections in listbox

2014-05-09 Thread Lew Schwartz
Is there a simple way to prevent multiple selections in a listbox (ie nothing happens if the shift or ctrl keys are held down). -Lew Schwartz --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _