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

On Jun 20, 9:38*am, groupie wrote:
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.

On Jun 20, 10:00*am, wrote:
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

On Jun 20, 9:38*am, groupie wrote:



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.- Hide quoted text -

- Show quoted text -

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

On Jun 20, 11:39*am, groupie wrote:
On Jun 20, 10:00*am, wrote:





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

On Jun 20, 9:38*am, groupie wrote:

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.- Hide quoted text -

- Show quoted text -

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.- Hide quoted text -

- Show quoted text -

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
_______


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.


"groupie" wrote in message
...
On Jun 20, 10:00 am, wrote:
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

On Jun 20, 9:38 am, groupie wrote:



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.- Hide quoted text -

- Show quoted text -