| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Set addin reference at runtime. | Excel Programming | |||
| runtime 1004 on save as | Excel Programming | |||
| Before Save w Addin | Excel Programming | |||
| Save & Install AddIn with VBA | Excel Programming | |||
| save file as addin programatically | Excel Programming | |||
![gabch[_22_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
