LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ray Ray is offline
external usenet poster
 
Posts: 267
Default updateable constant?

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Keep lookup values constant tommcbrny Excel Discussion (Misc queries) 5 October 26th 06 05:53 PM
Find data in table with to set of constant values Engineer Excel Worksheet Functions 4 May 26th 06 08:42 AM
How to create a constant total column in Excel? james9662 Excel Worksheet Functions 1 April 25th 06 08:31 PM
Build an array constant with DATE function CliffD Excel Worksheet Functions 2 April 11th 06 02:51 PM
How to average one constant # to variable #s? A1:A2 A1:A3 A1:A4 Colfax Excel Worksheet Functions 1 March 2nd 06 02:49 AM


All times are GMT +1. The time now is 10:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"