Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Adel Kadi
  Where is Adel Kadi?
 Fairfax
 Virginia - United States
 Adel Kadi
 To: Eric den Doop
  Where is Eric den Doop?
 Houten
 Netherlands
 Eric den Doop
 Tags
Subject: RE: Excel SpreadSheet With VFP 6
Thread ID: 721 Message ID: 726 # Views: 1 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Tuesday, June 12, 2001 9:07:35 PM         
   


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

ENTIRE THREAD

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