Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Riccardo Pimpini
  Where is Riccardo Pimpini?
 Firenze
 Italy
 Riccardo Pimpini
 To: ho me
  Where is ho me?
 
 Philippines
 ho me
 Tags
Subject: RE: call Excel from VFP
Thread ID: 248784 Message ID: 248787 # Views: 4 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Microsoft Office Automation
Date: Wednesday, December 23, 2009 11:31:44 AM         
   


> > Hi All again,
> > I have to run an external application from a click event of a button with some parameters passed by command line...
> >
> > I explain mayself...
> >
> > run Excel exe passing it a string with the file to open
> >
> > someting like:
> >
> >
RUN <path>\excel.exe "cartel.xls" 

> >
> > but this actually doesent work...
> >
> > Is there a correct function in VFP?
> >
> > I know that you have probably already talked about this problem but i can't find the references..
> > you can also sen some links thanks...
> >
> >
> > Shinedom - Shining is free....
>
> 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....

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