Saving file overwrites AddIn

  • Thread starter Thread starter groupie
  • Start date Start date
G

groupie

Hi,
An AddIn creates a menu item which opens a new excel form (with a
little bit of formatting: colours etc.). When this file is saved -
under a different filename, in a different directory, with .XLS - and
excel is closed down afterwards, when the menu item is selected again,
it seems to open the file just saved - has all the data etc.

Any ideas? Why doesn't the blank form display again when the menu
option is selected? Thanks.
 
Hi
As always, we need to see the AddIn code. More specifically, we need
to see the code that is run when the menu item is selected.
regards
Paul
 
Hi
As always, we need to see the AddIn code. More specifically, we need
to see the code that is run when the menu item is selected.
regards
Paul




- Show quoted text -
Click to expand...

Hi,
It just displays an excel sheet - nothing more than that. Can't
undeerstand why calling the addin "keeps" the data entered though?
There's nothing in the code for that.
 
Hi
Which sheet is being displayed? It might be that the sheet is part of
a workbook which contains the AddIn code. When you save you may be
also saving the AddIn code & in some way your menubar is for the saved
sheet, not the original AddIn. All a bit speculative without seeing
some code... What is the AddIn code that installs the menubar.
If you can email me the AddIn today I can look at it if you like.

regards
Paul
 
It just does this, how? As Paul pointed out twice, if you don't display the
code, or konwing where you're saving the file (is it overwriting the sheet1
or book1 template in the XLSTART directory, for instance?), you're not
letting us help.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
 
Back
Top