philippe pons
phpons at gmail.com
Wed Jul 2 03:52:43 CDT 2008
Hi all, I need your help! I have an A2003 application that is being used under A2007. This application exposes a customed menu bar, with a command button that triggers an Office link to Excel or Word. It allows the user to export reports to XL or Word. What happen under A2007 is that the custom menu bar is there, but not the Office Link button. However, the following VBA command: ?Application.CommandBars("myCustomedMenuBar").Controls(9).caption returns &Liaisons Office (i.e Office Link), showing that the control is still there within the command bar. Both properties Enable and Visible of this control are true. But the control will not display!! Do you know how I could give a new birth to this control? Or is it possible to recreate such a command by code? What I could you do is create a "normal" button, and give its onAction property the name of a function that will do the Office Link. But what is the VBA command that could do that? Thank's in advance for any help, Philippe