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: Jun Tangunan
  Where is Jun Tangunan?
 Cabanatuan
 Philippines
 Jun Tangunan
 Tags
Subject: RE: Minimize Ribbon in Excel 2007?
Thread ID: 269081 Message ID: 269124 # Views: 36 # Ratings: 3
Version: Visual FoxPro 9 Category: Active X Controls & OLE Automation
Date: Friday, July 16, 2010 12:53:16 PM         
   


> Does anyone know how to programmatically minimize ribbon in excel 2007 inside VFP? And if we can, how to show it back again. Thanks!
>
>
>
> http://www.junblogs.com/
> http://weblogs.foxite.com/sandstorm36/default.aspx
> http://www.coderisland.com/forum/viewforum.php?f=10

you can use also a macro run from vfp like this code
*!*--Author Yousfi Benameur El Bayadh Algeria
*!*--Time stamp vendredi 16 juillet 2010; 11:51:00
*!*--Subject :Cut the excel ribbon  programmatly
*!*--Version VFP9SP2

Local loObject As Excel.Application
loObject = Createobject("Excel.Application")
loObject.Workbooks.Add()
loObject.Visible = .T.


oo=loObject.CommandBars.Item("Ribbon")
If oo.Height >0
x='show.Toolbar("Ribbon",False)'
loObject.ExecuteExcel4Macro(m.x)
endi



you can also alternatively use

wscript.shell with sendkey from vfp
keybd API (send keys also) from vfp


Regards
Yousfi Benameur

ENTIRE THREAD

Minimize Ribbon in Excel 2007? Posted by Jun Tangunan @ 7/16/2010 10:52:12 AM
RE: Minimize Ribbon in Excel 2007? Posted by Anil Sharma @ 7/16/2010 11:39:13 AM
RE: Minimize Ribbon in Excel 2007? Posted by Mike Gagnon @ 7/16/2010 11:47:48 AM
RE: Minimize Ribbon in Excel 2007? Posted by Jun Tangunan @ 7/16/2010 11:47:50 AM
RE: Minimize Ribbon in Excel 2007? Posted by Anil Sharma @ 7/16/2010 11:56:50 AM
RE: Minimize Ribbon in Excel 2007? Posted by Jun Tangunan @ 7/16/2010 12:01:09 PM
RE: Minimize Ribbon in Excel 2007? Posted by Anil Sharma @ 7/16/2010 12:05:08 PM
RE: Minimize Ribbon in Excel 2007? Posted by Jun Tangunan @ 7/16/2010 12:08:42 PM
RE: Minimize Ribbon in Excel 2007? Posted by Jun Tangunan @ 7/16/2010 12:19:58 PM
RE: Minimize Ribbon in Excel 2007? Posted by Anil Sharma @ 7/16/2010 1:08:21 PM
RE: Minimize Ribbon in Excel 2007? Posted by Jun Tangunan @ 7/16/2010 1:40:12 PM
RE: Minimize Ribbon in Excel 2007? Posted by Anil Sharma @ 7/16/2010 2:08:53 PM
RE: Minimize Ribbon in Excel 2007? Posted by Mike Gagnon @ 7/16/2010 11:44:01 AM
RE: Minimize Ribbon in Excel 2007? Posted by Jun Tangunan @ 7/16/2010 11:51:08 AM
RE: Minimize Ribbon in Excel 2007? Posted by Borislav Borissov @ 7/16/2010 11:44:15 AM
RE: Minimize Ribbon in Excel 2007? Posted by Jun Tangunan @ 7/16/2010 11:53:41 AM
RE: Minimize Ribbon in Excel 2007? Posted by Yousfi Benameur @ 7/16/2010 12:53:16 PM
RE: Minimize Ribbon in Excel 2007? Posted by Jun Tangunan @ 7/16/2010 1:43:55 PM