Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Yousfi Benameur
  Where is Yousfi Benameur?
 El Bayadh
 Algeria
 Yousfi Benameur
 To: Bernard Bout
  Where is Bernard Bout?
 Brisbane
 Australia
 Bernard Bout
 Tags
Subject: RE: Open Excel file in VFP form
Thread ID: 188308 Message ID: 189371 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Microsoft Office Automation
Date: Thursday, August 14, 2008 4:07:07 PM         
   


> > hi experts
> >
> > Is there a way with which i could open an Excel file in a VFP form. for example there should be rectangular region in which the contents of the Excel file could be displayed and edited.
> >
> > and if possible can i use some of the excel tools there like 'Excel Filtering' etc.
> >
> > thanks in advance
> >
> > nishant
>
> Will this idea help any? It actually "embeds" excel into your form so anything you can do with Excel you can do here.
>
> Message ID: 129391
>
> Bernard
>
> ** If you see someone without a smile, give em one of yours :) **
> My Blog 8-)

Hi Bernard !
This is an interessting thing but needs to be completed.

1-the application window is pasted on the form but is not recognized as control of the form , especially since it did not have object name.
If the object had a name you might position themselves in the form or resize and fix it.
Window remains floating shift manually on form.its not fixe and is a foreign object to the form without proprétés or methods.
if you list the form controls you dont find it !

2-The caption of the window depends on the language of use. In french eg "Sans titre - Bloc-notes" .Yes the window caption must be very fine (==).

3. On may with some API (?) To remove the title bar / menu of the window...make the window fixed no movable.. problem but to save the file before....
If only the menu stay its maybe the solution.

5. As an oleobject the activeX is a fully control of the form,have properties,methods,and events in sense OOP.

As this method i prefer put a commandbutton and "shellexecute" the application with "SetWindowPos" on the screen.
At least it not occupy space on the form.

Best wishes
Yousfi Benameur

ENTIRE THREAD

Open Excel file in VFP form Posted by Nishant Gupta @ 8/8/2008 6:17:18 PM
RE: Open Excel file in VFP form Posted by Anders Altberg @ 8/8/2008 6:28:59 PM
RE: Open Excel file in VFP form Posted by Samir Ibrahim @ 8/9/2008 11:47:27 AM
RE: Open Excel file in VFP form Posted by Anders Altberg @ 8/9/2008 1:33:33 PM
RE: Open Excel file in VFP form Posted by Yousfi Benameur @ 8/8/2008 7:07:14 PM
RE: Open Excel file in VFP form Posted by Nishant Gupta @ 8/9/2008 11:45:47 AM
RE: Open Excel file in VFP form Posted by Anil Sharma @ 8/8/2008 7:30:02 PM
RE: Open Excel file in VFP form Posted by Samir Ibrahim @ 8/9/2008 11:42:40 AM
RE: Open Excel file in VFP form Posted by Bernard Bout @ 8/14/2008 5:34:31 AM
RE: Open Excel file in VFP form Posted by surinder singh @ 8/14/2008 8:12:56 AM
RE: Open Excel file in VFP form Posted by Bernard Bout @ 8/14/2008 4:48:50 PM
RE: Open Excel file in VFP form Posted by Nishant Gupta @ 8/15/2008 9:23:26 AM
RE: Open Excel file in VFP form Posted by Bernard Bout @ 8/15/2008 11:28:05 AM
RE: Open Excel file in VFP form Posted by Nishant Gupta @ 8/15/2008 8:05:01 PM
RE: Open Excel file in VFP form Posted by Samir Ibrahim @ 8/14/2008 10:30:11 AM
RE: Open Excel file in VFP form Posted by Nishant Gupta @ 8/14/2008 2:57:07 PM
RE: Open Excel file in VFP form Posted by Samir Ibrahim @ 8/16/2008 3:34:01 PM
RE: Open Excel file in VFP form Posted by Yousfi Benameur @ 8/14/2008 4:07:07 PM
RE: Open Excel file in VFP form Posted by Bernard Bout @ 8/15/2008 3:14:36 AM
RE: Open Excel file in VFP form Posted by Yousfi Benameur @ 8/20/2008 12:52:43 AM
RE: Open Excel file in VFP form Posted by Bernard Bout @ 8/20/2008 8:20:47 AM
RE: Open Excel file in VFP form Posted by Cetin Basoz @ 8/15/2008 11:36:39 AM
RE: Open Excel file in VFP form Posted by Yousfi Benameur @ 8/15/2008 6:02:59 PM
RE: Open Excel file in VFP form Posted by Cetin Basoz @ 8/16/2008 4:57:26 PM
RE: Open Excel file in VFP form Posted by Nishant Gupta @ 8/15/2008 8:13:35 PM
RE: Open Excel file in VFP form Posted by Yousfi Benameur @ 8/15/2008 6:58:44 PM
RE: Open Excel file in VFP form Posted by Nishant Gupta @ 8/15/2008 8:15:31 PM
RE: Open Excel file in VFP form Posted by Tarik AlKathiri @ 8/16/2008 3:00:25 PM
RE: Open Excel file in VFP form Posted by Yousfi Benameur @ 8/16/2008 3:59:21 PM
RE: Open Excel file in VFP form Posted by Tarik AlKathiri @ 8/18/2008 12:25:50 PM