Save addin in runtime
 

Hi,

Since addin is not a workbook, then save buttom is inactive.
Can I save the addin again?


--
gabch
------------------------------------------------------------------------
gabch's Profile: http://www.excelforum.com/member.php...o&userid=30662
View this thread: http://www.excelforum.com/showthread...hreadid=540518

Save addin in runtime
 

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
--
HTH...

Jim Thomlinson


"gabch" wrote:


Hi,

Since addin is not a workbook, then save buttom is inactive.
Can I save the addin again?


--
gabch
------------------------------------------------------------------------
gabch's Profile: http://www.excelforum.com/member.php...o&userid=30662
View this thread: http://www.excelforum.com/showthread...hreadid=540518

Save addin in runtime
 

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.
--
Stefano Gatto


"Jim Thomlinson" wrote:

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
--
HTH...

Jim Thomlinson


"gabch" wrote:


Hi,

Since addin is not a workbook, then save buttom is inactive.
Can I save the addin again?


--
gabch
------------------------------------------------------------------------
gabch's Profile: http://www.excelforum.com/member.php...o&userid=30662
View this thread: http://www.excelforum.com/showthread...hreadid=540518