Save addin in runtime

  • Thread starter Thread starter gabch
  • Start date Start date
G

gabch

Hi,

Since addin is not a workbook, then save buttom is inactive.
Can I save the addin again?
 
At run time you could save by adding some code to execute

Thisworkbook.Save

Otherwise you can manually save by hitting the save button in the VBE
 
Sorry to contradict you, but to me an addin IS very very similar to a
workbook, I mean it must contain at least one worksheet and especially can
contain data: this data can be changed at runtime (through userforms for
example), and if you need to find back that data in a further session then
you need to save the addin, programatically. (Beware, if Excel is not
instructed to save the addin, then Excel won't warn the user that some
unsaved data will be lost on quitting!).

Also because an addin is quite like an hidden workbook, simultaneous write
access won't work (never tried to make an addin from a shared workbook
though). Use Access if you need to achieve that.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COM addin won't connect when workbook opened via another workbookfrom another instance 3
Trouble Installing Excel VBA Code Cleaner into Office 365 0
Addins with isaddin property to false in excel 2007 4
Workbook properties code in the xla addin 10
Custom Addin Reference Crashes Excel 6
Copy a Sheet to an AddIn 2
Excel VBA 2
Cannot find/see AddIns 4

Back
Top