Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Tony Vignone
  Where is Tony Vignone?
 St Augustine
 Florida - United States
 Tony Vignone
 To: Cecil Champenois
  Where is Cecil Champenois?
 Little Elm
 Texas - United States
 Cecil Champenois
 Tags
Subject: RE: Office 2010 files crash VFP
Thread ID: 395524 Message ID: 395546 # Views: 43 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Windows 7 and VFP
Date: Wednesday, January 15, 2014 7:33:06 PM         
   


> >
> > I have never seen this type of crash. Can you email me a file which makes VFP crash, so that I can test it myself?
> >
> > Are you forced to use xls format? With VFP, xl5 has proved to be a better format. Also with Excel 2007 and 2010 you can use xlsx. To read a xlsx file into VFP, you can use Craig Boyd's tool which you find at http://www.sweetpotatosoftware.com/spsblog/2008/09/30/UsingExcel2007FileFormatsInVFP90.aspx.
> >
> > There's a fine line between helping and adding to the confusion.
> >
> > How to create sample data
>
> We COPY TO or APPEND FROM everything as TYPE XL5, if it is EXCEL. If someone sends us an EXCEL file from 2010 Excel then we have to take it back down to Excel 95/5.0.
>
> I think I'll take a look at Craig's Boyd's code to be able to USE EXCEL 97-2003 and perhaps even 2010. Anyone know if his code will work for 2010 files also?
>
> Cecil Champenois, Jr.


I am using you solution. It works. Thanks, Cecil.

Tony

ENTIRE THREAD

Office 2010 files crash VFP Posted by Tony Vignone @ 1/15/2014 5:51:20 PM
RE: Office 2010 files crash VFP Posted by Koen Piller @ 1/15/2014 6:01:38 PM
RE: Office 2010 files crash VFP Posted by Tony Vignone @ 1/15/2014 7:28:06 PM
RE: Office 2010 files crash VFP Posted by Tore Bleken @ 1/15/2014 6:04:18 PM
RE: Office 2010 files crash VFP Posted by Koen Piller @ 1/15/2014 6:30:29 PM
RE: Office 2010 files crash VFP Posted by Tore Bleken @ 1/15/2014 6:37:14 PM
RE: Office 2010 files crash VFP Posted by Cecil Champenois @ 1/15/2014 6:53:22 PM
RE: Office 2010 files crash VFP Posted by Tore Bleken @ 1/15/2014 6:57:03 PM
RE: Office 2010 files crash VFP Posted by Tony Vignone @ 1/15/2014 7:33:06 PM
RE: Office 2010 files crash VFP Posted by Tony Vignone @ 1/15/2014 7:32:12 PM
RE: Office 2010 files crash VFP Posted by Tony Vignone @ 1/15/2014 7:48:08 PM
RE: Office 2010 files crash VFP Posted by Tore Bleken @ 1/15/2014 8:12:11 PM
RE: Office 2010 files crash VFP Posted by Tony Vignone @ 1/16/2014 12:51:19 AM
RE: Office 2010 files crash VFP Posted by Jun Tangunan @ 1/15/2014 11:51:14 PM
RE: Office 2010 files crash VFP Posted by Tony Vignone @ 1/16/2014 12:50:31 AM