Hi,

I have created an Excel Workbook application using VBA UserForms. This
workbook has a sheet dedicated to store some configuration data
required for this application and a UserForm to change these
configuration settings.

I published this file as an Excel Add-In (.XLA). I faced issues when I
change this data it is saved for the session in which this data is
updated. However when I close Excel completely, these changes are
gone. I want to keep these changes in Add-In's Workbook.

I can do this with INI or XML; however I want to keep these changes in
to Add-In’s Workbook only.

Please advice.

Thanks in advance,
Unmesh

Try ThisWorkbook.Save after making thed changes to the configuration sheet.


--
Charles Williams
Decision Models

"Unmesh" wrote in message
...
Hi,

I have created an Excel Workbook application using VBA UserForms. This
workbook has a sheet dedicated to store some configuration data
required for this application and a UserForm to change these
configuration settings.

I published this file as an Excel Add-In (.XLA). I faced issues when I
change this data it is saved for the session in which this data is
updated. However when I close Excel completely, these changes are
gone. I want to keep these changes in Add-In's Workbook.

I can do this with INI or XML; however I want to keep these changes in
to Add-In’s Workbook only.

Please advice.

Thanks in advance,
Unmesh

Thanks Charles,

This worked for me.

Cheers!!
Unmesh

On Aug 14, 12:34*pm, "Charles Williams"
wrote:
Try ThisWorkbook.Save after making thed changes to the configuration sheet.