Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I create a file to send to other's that updates module 1?
Hi all,
I created a spreadsheet that a number of users have on their hard drives -- I'm wondering how I can make code updates to their files without actually opening their files? I was wondering if there is a way that I can create a "fix file" with the updated code that when the user clicks on a button in the "fix file", the code in this "fix file" will do the following: 1 - Identify the file that needs to be updated (maybe by having a menu that comes up that allows the user to navigate through their hard drive (like windows explorer) and select and/or open the file that needs to be updated) 2 - Once the file on their hard drive is identified/open, the "fix file" will copy the code that exists in say module 1 of the "fix file" and then go to say module 8 of the user's file and paste over any existing code in module 8. 3 - The user's file will then save Any help you can give me is appreciated! If there is something that exists on the internet somewhere that details how to do this, that would be great. Thanks. -- Robert |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I create a file to send to other's that updates module 1?
Thanks Gary. Yeah, I thought about this after posting it last night -- the
reason I didn't want to go that way in the first place was because each user will have their own set of unique data stored within the spreadsheet and I wanted to avoid requiring the users to re-input data into the spreadsheet everytime there was a new version. What I should have realized all along is that I can have code within the new version that pulls the needed data from each user's older version. I'm guessing that's the best way to do this. If not, please let me know. Thanks! -- Robert "Gary''s Student" wrote: Change your distribution method: 1. Create a public copy of the file on a shared network drive or SharePoint, etc. 2. Establish some kind of publish/subscribe system to e-mail the user community that a new version is available after you have made modifications 3. Give the users instructions to download the latest version Basically this is a Burger King way of doing business rather than a Red Lobster approach. Don't play waiter, bring meals to the counter, not the individual tables. -- Gary''s Student - gsnu200766 "robs3131" wrote: Hi all, I created a spreadsheet that a number of users have on their hard drives -- I'm wondering how I can make code updates to their files without actually opening their files? I was wondering if there is a way that I can create a "fix file" with the updated code that when the user clicks on a button in the "fix file", the code in this "fix file" will do the following: 1 - Identify the file that needs to be updated (maybe by having a menu that comes up that allows the user to navigate through their hard drive (like windows explorer) and select and/or open the file that needs to be updated) 2 - Once the file on their hard drive is identified/open, the "fix file" will copy the code that exists in say module 1 of the "fix file" and then go to say module 8 of the user's file and paste over any existing code in module 8. 3 - The user's file will then save Any help you can give me is appreciated! If there is something that exists on the internet somewhere that details how to do this, that would be great. Thanks. -- Robert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a histogram that updates when I filter the input ran | Excel Worksheet Functions | |||
How do I create a sheet in Excel that updates itself from other sh | Excel Worksheet Functions | |||
How do I create spreadsheet that automatically updates numbers/va. | Excel Discussion (Misc queries) | |||
How to view other's reply in search mode... | Excel Programming | |||
How to create two validation lists that modify each other's value? | Excel Programming |