Hi guys,
Question:
------------
--> Is there a way to tell an excel session not to record settings when closing? <--
Explanations:
----------------
I have a first add-in, AddIn1, which creates a submenu, say 'Run AddIn2', in the xl Tools menu.
When this menu is clicked:
- it opens a separate session of Excel, say session2.
- it loads the addin called AddIn2 in this new session of Excel.
Now in this new session, when AddIn2 is loaded, it makes many changes to the Excel environment: changing settings in the Options dialog, changing toobars, menus... for its specific use.
Concurrently the user may or may not have closed the first excel session and may or may not have opened new Excel sessions.
Problem:
-----------
When Excel closes, it records the latest settings: changes in the Options dialog, changes in toobars, menus,...
So, if session2 of excel is the last one to be closed, it will save these settings.
--> this is what i am trying to prevent.
So the main question is:
--> Is there a way to tell an excel session not to record settings when closing? <--
Ideas:
-------
1 - Save all changes addin2 makes to the Excel environment and restore them before closing. Too many changes and i am not sure yet that everything can be reversed 100%.
2 - Before closing, addin2 in session2 creates a new excel session, say session3.
Since session2 has not been closed yet, session2's settings have not been saved yet, therefore the session3 will open with the old settings. Then session2 closes recording its settings and session3 closes overwritting with its settings.
But how to make sure session3 closes right after session2 so that session3's settings becomes the default ones.
3 - Have session1 open session2 of excel with the Safe switch (/s) which launches excel with no addin, with the default toolbars (when excel was set up), then the code of addin1 in session1 loads addin2 in session2.
However, i am not completely sure what Safe mode does.
At least, it doesn't seem to record settings when closing.
Is that true?
Does xl lacks functionality in safe mode or is there things that cannot be done in that mode (besides the non-loaded usual addins)?
4 - Any other ideas are very welcome.
Thank you,
Regards,
Sebastien
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Hi Matthew,
>>> Starting Excel with switch so that it doesn't record the changes (toobars, addins, ...)
Doesn't seem to be such a thing
I guess saving the changes of toolbars, addins, ... and set them back are my only options.
The problm is that some changes may have already been made by other addins or processes that loaded prior to my addin and may be context sensitive, therefore setting them back might be wrong and may not een work due to the context-sensitivity issue. But well, i guess i'll have to go with that!
I'll wait until next week and see if anybody has a better idea.
Thank you,
Sebastien
Business Accounts
Answer for Membership
by: sebastienmPosted on 2004-07-27 at 23:54:26ID: 11653986
Actually, with idea3 (/s switch), excel prompts the user for his name as it does right after installation. And since excel doesn't load any addin dur to the switch, i suppose no code can be ran to prevevnt that. So this idea won't work.
Sebastien