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


> >
> > 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

You've created XLS files in VFP; open one of them with MODIFY FILE some_name.xls and you 'll see that's it's a binary file and would take an awful lot of insider knowledge to create.
What's your problem with distributing a tab-delimited textfile? Excel opens it without any problems.

-Anders

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