Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Simon Arnold
  Where is Simon Arnold?
 United Kingdom
 Simon Arnold
 To: Adel Kadi
  Where is Adel Kadi?
 Virginia - United States
 Adel Kadi
Subject: RE: Excel SpreadSheet With VFP 6
Thread ID: 721 Message ID: 732 # Views: 1 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Wednesday, June 13, 2001 2:26:24 AM         

> > > Hi everybody
> > > I did a Sheet using Excel Office97 for a friend of mine with totals and I tried to use
> > > OLE to put it on a form so the sheet on the form but when you run the form you
> > > can't do anything with the sheet.I was thinking if i can enter information into the sheet like
> > > i do in excel so may be i can make it *.EXE file then thinking he can use this sheet
> > > as standalone so he doesn't need to have excel on his computer.Is this make
> > > any sense ? I don't know!
> > > Thanks everybody
> > > kadi
> >
> > Hello,
> >
> > Nope. You need Excel to work with Excel files, or perhaps a free tool like StarOffice can read Excel files. Corel has a spreadsheet program as well, but i've forgotten its name.
> >
> > If you use Excel as OLE object, then you *must* have Excel installed, otherwise the OLE does not work.
> >
> > Have you tried automation?
> > loExcel = CREATEOBJECT("Excel.Application")
> > loExcel.workbooks.open("c:\my documents\mysheet.xls")
> > loExcel.visible = .T.
> > --
> > Eric den Doop
> > www.foxite.com - The Home Of The Visual FoxPro Experts
> Hi Eric
> Thanks very much you are very helpful i tried this code and it works But like you said
> the person has to have excel on his computer I just thought about those tools from corel
> and StarOffice do they work the same i mean does he got to have them too installed
> on his computer or you can use them within VFP6 then make *.EXE file and it will
> be Standalone that he doesn't need any thing except VFP6 Runtime?
> Thanks again very much
> kadi

Any Automation via VFP will require the appropriate application to be installed first.
I do have a piece of VB code that creates an Excel file from code.
Drop me a line if you would like a copy of this.

Simon Arnold
Westlake Computer Systems Ltd.
Halifax, UK.


Excel SpreadSheet With VFP 6 Posted by Adel Kadi @ 6/12/2001 5:08:15 PM
RE: Excel SpreadSheet With VFP 6 Posted by Eric den Doop @ 6/12/2001 5:47:17 PM
RE: Excel SpreadSheet With VFP 6 Posted by Adel Kadi @ 6/12/2001 9:07:35 PM
RE: Excel SpreadSheet With VFP 6 Posted by Simon Arnold @ 6/13/2001 2:26:24 AM