Storing configuration data in XLA file

[Unmesh]

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

 

[Charles Williams]

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


--
Charles Williams
Decision Models

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

 

[Unmesh]

Thanks Charles,

This worked for me.

Cheers!!
Unmesh