updateable constant?

[Ray]

Hello -

I'm designing a forecast package that will be (hopefully) used for some
years to come. I'd like to build the pkg to be 'updateable' with
little effort or technical knowledge, but not sure how to proceed.
Here's what I'd like to do...

Every month, the pkg is updated and saved to a specific folder (ie
'FY06'). This folder will be used all year (so a 'constant'), but will
change next September (to 'FY07'). This pkg will be used by over 30
stores, so I need a way to update the path to the new folder without
having to personally go into each store's pkg and update the vba code
myself.

I was thinking of utilizing a userform (accessed via a button) to
collect the updated info and somehow 'pass' it to where it needs to go.
Can this be done? If so, where should I put the 'variable constants'
within the structure of the Code?

TIA!

ray

 

[Ray]

Thanks for the response -- 2 thoughts on this:
** this would definitely work, except that 'upper mgmt' won't like
it....
** the FY example is just one of many (6-8) semi-variable constants
that I want to setup

Any other ideas?

 

[Ray]

I think the answer to my question is to set up a UserForm to collect
all of my semi-constant variables -- the administrator could click a
button to call-up the userform, enter any updates, and this would
update the 'constants' until the next time the button is pushed.

BUT, how do I set this up? I know how to build the UserForm, but where
do I go from here? Where is the data stored and how would I reference
these fields in other modules/subs?

 

[MartinW]

Sounds like a perfect situation for Google Spreadsheets to me!
Just put "google spreadsheets" into a google search.

 

[Ray]

Hi Martin -

Not sure how this solves my issue....can you clarify a bit you thinking
on this?

TIA, ray