Add-In and Save Dialog-Box

[pmguerra]

Hi!

I'm building my first Add-In, which I'm using to gather all Sub's that I've created through my small VBA writting career.

The thing is that when I write new code and some reason exit Excel and forget to save the XLA, obviously the code is lost.

I've used:

Please Login or Register  to view this content.

but obviously, if I write garbagge or delete precious code, all is lost.

Is there a way for Excel to ask me if I want to save the XLA file, like it does when changes are made to a common worksheet?

I've tried the Save Dialogs but they all ask for new file name. I just want a simple "do you wish to save blabla.xla?" question...

Thank you!

[royUK]

You can save the .xla from the VB Editor when you make changes.

It's really best to do all the VBA work before converting to an addin, however to update the addin it's best to go into the addin's properties in the VB Editor and change IsAddin to False , make the changes then change back to true after saving

[Andy Pope]

You could try this,

Please Login or Register  to view this content.

[martesoft]

I tend to develop my XLAs as an XLS. This gives me much more flexibility when developing, I can see what is in the addin sheets etc. When it is ready to test, I just save as an XLA as well as XLS.

[pmguerra]

Thank you guys!

I'll try out your suggestions!