MWE wrote:
*Keith: thank you for your reply. I have used hidden sheets in the
past. That works but it does seem like brute force. Wirting to the
Registry or a separate file has the disadvantage of not being
"portable".

Thanks again *

Agree, it is best to keep the data with you. The regestry can be nice
since no matter where you move the excel sheet it will still look
there, but if you move it on another machine then you have to start
over. My perfered way is hidden sheets, as long as you are using semi
fast machines and have good memory brute force is sometimes the best
way. If you wanted to be sexy about it you could create a web service
that will send or recieve values from your app that are stored/written
to a database on a web server, if you are using this in a corporate
environment you dont have to worry about internet connection. But
would I do this over a hidden sheet, only if I was getting paid extra
for overtime.

Keith
www.kjtfs.com


---
Message posted from http://www.ExcelForum.com/