Excel object as "imbedded" editor in VB application 
Author Message
 Excel object as "imbedded" editor in VB application

I've written a VB application that uses an instance of EXCEL as a data
editor.  The idea is that an intelligent EXCEL form is constructed, and
the user interacts with it, until they are happy with their data.  They
then leave the editor and return to the parent application.

I began manipulating the file menu in order to mimic other "imbeded
applications" that allow the user only two options: abort; or update and
return.  I successfully mainpulated the File menu by modifying the
appropriate CommandBars("Fi le") controls.  However, when I removed recent
files, via MyAp.DisplayRecentFiles = False, the list of files is gone
forever, even though I later set this toTrue.  I've tried unsuccessfully
to save the list of files using the commandBars("File").Controls(13-I),
where I=MyAp.RecentFiles.Count, for later reinsertion.

To my surprise, all of these manipulations to the Excel object seem to
affect all instances of excel.  An y changes I make to the commandbars
file menu controls effect all future Excel objects.  If program execution
doesn't bomb out, t he menus get reset to original (except for missing the
recent files), because I've had to included excel command bar resetting
comands, at the winddown of my VB app.  Ts there any way to limit my
commandbar manipulations to my single instance of excel, or else at least
restore the recent file list before I finish my application?
               Thanks in advance for any help,

------------------  Posted via CNET Help.com  ------------------

Sat, 30 Mar 2002 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Dispatch("Excel.Application") = Access denies

2. "Object-Oriented Applications": publication announcement (long)

3. Counting an Applications "objects"

4. "Object-Oriented Applications": publication announcement (long)

5. string.join(["Tk 4.2p2", "Python 1.4", "Win32", "free"], "for")

6. "solver" function that is in Excel

7. "Assembly in VB - in windows 95 ?"

8. VB-type "Declare" in Tcl

9. LOOKING for "BRIEF" Text Editor

10. VHDL "Folding Editor"?

11. bug fixed in "Handy" Spline Editor

12. "Handy" Spline Editor


Powered by phpBB® Forum Software