Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: M. Akram Bhatti
  Where is M. Akram Bhatti?
 Riyadh
 Saudi Arabia
 M. Akram Bhatti
 To: Riccardo Pimpini
  Where is Riccardo Pimpini?
 Firenze
 Italy
 Riccardo Pimpini
 Tags
Subject: RE: call Excel from VFP
Thread ID: 248784 Message ID: 248789 # Views: 3 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Microsoft Office Automation
Date: Wednesday, December 23, 2009 12:00:10 PM         
   


> >
> > Hi,
> >
> > Maybe you can use automation
> >
> >
> >
> > loExcel = CREATEOBJECT( 'excel.application' )
> > loExcel.VISIBLE = .T.
> > 

>
> Thanks for the reply it seems is the code I was looking for...
>
> I tryed this code even in built time and in run time but there is something that doesen't work...
> in run time my form flashes black for half second than all turns normal but no excels are opened...
>
> maybe I have to set some other parameters of the object...
>
> I suppose parameter passing is someting like this....
>
>
>  loExcel = CREATEOBJECT( 'excel.application','cartel.xls' )
>  loExcel.VISIBLE = .T.
>  

>
> Am I right?
>
> Let me know.
>
> Thank for now.
>
> Shinedom - Shineing is free....

If you want to create new File:

oEx = CREATEOBJECT('Excel.Application')
oWB = oEx.WorkBooks.Add()
oXS = oWB.ActiveSheet
oEx.Visible = .t.
oEx.DisplayAlerts = .F.
oXS.Range('A1').Value = "Hello World"
oWB.SaveAS(FULLPATH(CURDIR()) + "myExcel.xls")

Regards,
Akram

ENTIRE THREAD

call Excel from VFP Posted by Riccardo Pimpini @ 12/23/2009 11:09:30 AM
RE: call Excel from VFP Posted by ho me @ 12/23/2009 11:15:39 AM
RE: call Excel from VFP Posted by Riccardo Pimpini @ 12/23/2009 11:31:44 AM
RE: call Excel from VFP Posted by M. Akram Bhatti @ 12/23/2009 11:36:59 AM
RE: call Excel from VFP Posted by Riccardo Pimpini @ 12/23/2009 12:06:32 PM
RE: call Excel from VFP Posted by M. Akram Bhatti @ 12/23/2009 12:11:58 PM
RE: call Excel from VFP Posted by Anders Altberg @ 12/23/2009 12:31:54 PM
RE: call Excel from VFP Posted by Stefan Wuebbe @ 12/23/2009 4:12:52 PM
RE: call Excel from VFP Posted by M. Akram Bhatti @ 12/23/2009 12:00:10 PM
RE: call Excel from VFP Posted by Stefan Wuebbe @ 12/23/2009 12:05:21 PM
RE: call Excel from VFP Posted by Riccardo Pimpini @ 12/23/2009 12:18:24 PM
RE: call Excel from VFP Posted by tushar @ 12/23/2009 1:11:17 PM
RE: call Excel from VFP Posted by Riccardo Pimpini @ 12/23/2009 2:08:23 PM
RE: call Excel from VFP Posted by tushar @ 12/23/2009 3:27:06 PM
RE: call Excel from VFP Posted by Stefan Wuebbe @ 12/23/2009 4:18:01 PM
RE: call Excel from VFP Posted by Stefan Wuebbe @ 12/23/2009 4:43:31 PM
RE: call Excel from VFP Posted by Cetin Basoz @ 12/23/2009 3:40:39 PM