Re^2: Absolute simplest way to keep a database variable persistent?

[natestraight]

Ah.

Unfortunately, I'd really like the work to be done inside Excel as the whole point of the project is to be dynamic (i.e. call the Perl script as part of a volatile VBA function), with the parameters changing based on user input.

The Excel sheet contains data that is automatically refreshed daily from a ton of blog feeds, and the WordNet modules are going to be used to perform some semantic analysis based on selected user-specified blog posts, phrase lengths, etc.

Nevertheless, it's not entirely impossible that this be done outside of Excel. I could dump the entire worksheet into a MySQL database or the like, but then I really lose a lot of the dynamic, auto-refresh capabilities that I'd like.

I'll look into this option, though, as it sounds like it would at least work. Thanks.