Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: M. Akram Bhatti
  Where is M. Akram Bhatti?
 Riyadh
 Saudi Arabia
 M. Akram Bhatti
 To: madiha saleem
  Where is madiha saleem?
 lahore
 Pakistan
 madiha saleem
 Tags
Subject: RE: use xlsx rather than xls
Thread ID: 249143 Message ID: 249150 # Views: 1 # Ratings: 3
Version: Visual FoxPro 5 Category: Projects and Design
Date: Tuesday, December 29, 2009 1:51:41 PM         
   


> hi experts,
> i m using copy command to convert a table in data in excel but im using office 2007 edition but when i give type xlsx it returns an error but when i use xls it convert all data in excel file:
> use slry
> copy to SlrySheet\BankSalarySlips type xls
> please tell me what i do....
> madiha saleem

You can use Automation for this purpose.

Use Slry
Copy To SlrySheet\BankSalarySlips Type XLS
If File("BankSalarySlips.xls") && Add full path here
  oEx = CREATEOBJECT('Excel.Application')
  oWB = oEx.WorkBooks.Open("BankSalarySlips.xls") && Add full path here
  oWB.SaveAS(FULLPATH(CURDIR()) + "BankSalarySlips.xlsx")
  oEx = Null
Endif


Regards,
akram

ENTIRE THREAD

use xlsx rather than xls Posted by madiha saleem @ 12/29/2009 12:50:40 PM
RE: use xlsx rather than xls Posted by Russell Hill @ 12/29/2009 12:55:52 PM
RE: use xlsx rather than xls Posted by Yahia Aboudalal @ 12/29/2009 12:57:37 PM
RE: use xlsx rather than xls Posted by Anders Altberg @ 12/29/2009 3:51:27 PM
RE: use xlsx rather than xls Posted by Yahia Aboudalal @ 12/30/2009 5:44:08 PM
RE: use xlsx rather than xls Posted by M. Akram Bhatti @ 12/29/2009 1:51:41 PM