Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Jerzy Kopinski
  Where is Jerzy Kopinski?
 Pruszcz Gdanski
 Poland
 Jerzy Kopinski
 To: tushar Kanvinde
  Where is tushar Kanvinde?
 Kolhapur, Maharastra
 India
 tushar Kanvinde
 Tags
Subject: RE: .CSV -> .XLS
Thread ID: 228729 Message ID: 228752 # Views: 4 # Ratings: 0
Version: Visual FoxPro 9 Category: Microsoft Office Automation
Date: Thursday, May 21, 2009 10:12:42 AM         
   


> > Hi ,
> > I have to convert .CSV file into .XLS file. How to do that using Excel Automation? Maybe someone could recommend me some links or sources with Office Automation (and Open Office) mechanism description and/or documentation for FVP Developers?
> > Thanks in advance,
> > Jerzy
>
>
>
>
loWS=CREATEOBJECT('excel.application')
> loWS.Workbooks.Open(FileNameWithFullPath)
> loWS.ActiveWorkbook.SaveAs(TargetFileNameWithFullPath,1)
> loWS.ActiveWorkbook.Close
> 

>
> Regards
> Tushar

Thanks Tushar, it works perfect.
Best regards,
Jerzy

ENTIRE THREAD

.CSV -> .XLS Posted by Jerzy Kopinski @ 5/21/2009 7:18:01 AM
RE: .CSV -> .XLS Posted by tushar @ 5/21/2009 7:28:31 AM
RE: .CSV -> .XLS Posted by Jerzy Kopinski @ 5/21/2009 10:12:42 AM