Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: JaiPrakash Bhandari
  Where is JaiPrakash Bhandari?
 Hyderabad
 India
 JaiPrakash Bhandari
 To: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 Tags
Subject: RE: EXPORT TO XLS Command
Thread ID: 227969 Message ID: 228489 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Microsoft Office Automation
Date: Tuesday, May 19, 2009 10:40:07 AM         
   


> > Hello Anders
> > Ur Idea Works. Thanks for it.
> > But finally, I have to create .Xls file. So, can u pls suggest me how to convert or 'Save As' that particular .Txt file into .Xls file programmatically.
> > Regards
> > Bhandari
>
> Try
>
> DEFINE xlWorkbookNormal -4143
> oXlWorkbook.SaveAs(path\filkename, xlWorkbookNormal)
> OR
> oXl.workBook.Activesheet.SaveAS(path\filename, xlWorkbookNormal) 
> 

> You can get a list of the constants in by dragging the Constants node from the Excel class you open in VFP's Objct Browser.
> -Anders
------------------------------------------
Hello Anders,
I want to Save it as .Xls by not opening the Excel file.
Is it possible programmatically through VFP ?
As, I think, that the previous codes requires the Excel application to be opened.

Regards
Bhandari

ENTIRE THREAD

EXPORT TO XLS Command Posted by JaiPrakash Bhandari @ 5/14/2009 1:57:45 PM
RE: EXPORT TO XLS Command Posted by Frank Cazabon @ 5/14/2009 2:45:21 PM
RE: EXPORT TO XLS Command Posted by Tamar Granor @ 5/15/2009 10:34:32 PM
RE: EXPORT TO XLS Command Posted by JaiPrakash Bhandari @ 5/18/2009 9:35:15 AM
RE: EXPORT TO XLS Command Posted by Anders Altberg @ 5/18/2009 9:54:33 AM
RE: EXPORT TO XLS Command Posted by JaiPrakash Bhandari @ 5/18/2009 1:26:14 PM
RE: EXPORT TO XLS Command Posted by Anders Altberg @ 5/18/2009 5:30:16 PM
RE: EXPORT TO XLS Command Posted by JaiPrakash Bhandari @ 5/19/2009 10:40:07 AM
RE: EXPORT TO XLS Command Posted by Anders Altberg @ 5/19/2009 2:36:53 PM