Store Information but not in a Workbook

  • Thread starter Thread starter Andibevan
  • Start date Start date
A

Andibevan

Hi All,

I have a large dynamic spreadsheet that has a number of different settings
which I am currently storing on a hidden worksheet.

Most of the settings are either True / False with some integers as well.

Is there a better / more profesional way that I can store the settings. Can
I write code that will update a VBA script or similar which holds all of the
setting information.

A few pointers on where to look would be very helpful.

Thanks

Andi
 
Look at GetSetting and SaveSetting which writes your values to the
registry.

You can also use defined names. (make them not visible).

However, if you have a lot of settings, I don't see anything unprofessional
using a hidden worksheet.
 
Thanks Tom that's great.

I only thought it would be unprofessional if there was another widely used
approach I had looked over.

Thanks

Andi
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vba Help with Information Extraction 0
How to store a reference of a excel workbook in a variable in vbsc 5
Store data in array 3
How to handle persistent properties in Excel VBA 2003 4
VBA to run all variable combinations in a calculation model and store result 6
Import multiple workbooks to current workbook in specified row number 0
Keeping XML data in workbook? 1
Store hidden information in a spreadsheet 10

Back
Top